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

NETWORKDAYS(DATE(2008, 1, 1), DATE(2009, 1, 1))NETWORKDAYS(DATE(2008; 1; 1); DATE(2009; 1; 1))

Returns 263, the number of working days between January 1, 2008, and January 1, 2009.

NETWORKDAYS(DATE(2008, 1, 1), DATE(2009, 1, 1), { DATE(2008, 5, 1) })NETWORKDAYS(DATE(2008; 1; 1); DATE(2009; 1; 1); { DATE(2008; 5; 1) })

Returns 262, the number of working days between January 1, 2008, and January 1, 2009, when May 1, 2008, is excluded from the calculation.