NETWORKDAYS

NETWORKDAYS

Synopsis

NETWORKDAYS (start_date,end_date[,holidays])

Description

NETWORKDAYS returns the number of non-weekend non-holidays between start_date and end_date including these dates. Holidays are optionally supplied in holidays.

  • NETWORKDAYS returns #NUM! if start_date or end_date are invalid.
  • This function is Excel compatible.

Examples

NETWORKDAYS(DATE(2001,1,2),DATE(2001,2,15)) equals 33.

See also

WORKDAY.