Excel NETWORKDAYS Function

Excel NETWORKDAYS Function


Get the number of working days between two dates

Return value 

A number representing days.


=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.

Usage notes 

Note: Working days exclude weekends and dates supplied as holidays.

NETWORKDAYS can be used to calculate employee benefits that accrue based on days worked, the number of working days available in a certain time range.

If you receive a #NAME? error when trying to use this function, install and load the Analysis ToolPak add-in.

1 votes. 5 / 5

Excel - Excel Functions - Excel Formulas