NETWORKDAYS function

NETWORKDAYS (Date1, Date2, Holidays?) NETWORKDAYS (Date1; Date2; Holidays?)

Date1

Temporal Temporal

The first date.

Date2

Temporal Temporal

The second date.

Holidays

An array of dates representing holidays, which are not considered working days. If omitted, only weekends are excluded from the calculation.

Returns

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