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