Purpose
Get the number of working days between two dates
Return value
A number representing days.
Syntax
=NETWORKDAYS (start_date, end_date, [holidays])
Arguments
- 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.