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

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

• 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

Example of NETWORKDAYS Function in Excel with holiday list

Formula

• 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