NETWORKDAYS function
NETWORKDAYS(Date1,
Date2, Holidays?) NETWORKDAYS(Date1;
Date2; Holidays?)
Date1
Number or { Number }
The first date, as a sequential serial number.
Date2
Number or { Number }
The second date, as a sequential serial number.
Holidays
{ Number } (optional)
An array of sequential serial numbers representing holidays, which are not considered working days. If omitted, only weekends are excluded from the calculation.
Returns
Number or { Number }
The number of working days between the given two dates.
Returns the number of working days between two dates. Weekends are excluded from the calculation, as are the holidays given as the third parameter. To customize what days are considered weekend days, use the NETWORKDAYS.INTL function instead.
Examples
Returns 263, the number of working days between January 1, 2008, and January 1, 2009.