NETWORKDAYS
Gets the number of working days between a specified beginning and ending date, inclusive. Working days exclude weekends and any dates optionally provided as holidays.
Syntax
=NETWORKDAYS(start, end, holidays)
Arguments
| Argument | Type | Description |
|---|---|---|
| start | Date | The beginning date to use for the calculation |
| end | Date | The end date to use for the calculation |
| holidays | Array(Date) | (Optional) Dates to exclude from the count of working days |
Examples
=NETWORKDAYS("2020-04-01", "2020-04-10")→8
Counts the days Mon-Fri within the range
=NETWORKDAYS("2020-04-01", "2020-04-01")→1
The range is inclusive, so if the start and end are the same day, the result is 1
=NETWORKDAYS("2020-04-07", "2020-04-2")→-4
If the end date is before the start date, a negative value is returned
=NETWORKDAYS("2020-04-01 :20:00", "2020-04-10 7:00")→8
If a time is included with the date(s), the time is ignored
=NETWORKDAYS("2020-04-01", "2020-04-15", ["2020-04-07", "2020-04-03", "2020-03-31"])→9
Holidays are excluded. Holidays outside the interval or on weekends are ignored
Updated 10 months ago