These docs are for v1.0. Click to read the latest docs for v1.2.

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

ArgumentTypeDescription
startDateThe beginning date to use for the calculation
endDateThe end date to use for the calculation
holidaysArray(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