NETWORKDAYS Function in Excel – Calculate number of working days between two dates

NETWORKDAYS Function in Excel calculates the number of working days between two dates. NETWORKDAYS Function automatically excludes weekends (Saturday and Sunday) and it can also exclude list of holidays that is provided as an input

 

Syntax for NETWORKDAYS Function in Excel

NETWORKDAYS (start_date, end_date, [holidays])

start_date – The start date.

end_date – The end date.

holidays – [optional] A list of one or more dates that should be considered non-work days

 

Example of NETWORKDAYS Function in Excel

Formula

NETWORKDAYS Function in Excel 1

  • 23 working days (excluding weekend) are there between Jan-1-2017 is Feb-1-2017
  • 22 working days (excluding weekend) are there between Jan-1-2017 is Dec-1-2017, because of start date less than end date number of working days will have negative value (-22).

So the result will be

Result

NETWORKDAYS Function in Excel 2

Example of NETWORKDAYS Function in Excel with holiday list

Formula

NETWORKDAYS Function in Excel 3

  • 21 working days (excluding weekend) and Excluding Holidays are there between Jan-1-2017 is Feb-1-2017
  • 22 working days (excluding weekend) and Excluding Holidays are there between Jan-1-2017 is Dec-1-2017, because of start date less than end date number of working days will have negative value (-22).

So the result will be

Result

NETWORKDAYS Function in Excel 4

previous-small NETWORKDAYS Function in Excel                                                                                                                next_small NETWORKDAYS Function in Excel