Google Sheets function
NETWORKDAYS function in Google Sheets
NETWORKDAYS in Google Sheets returns the number of working days between two dates, including both endpoints and excluding Saturdays and Sundays. An optional holiday range removes additional dates. Use it to measure business-day schedules, service windows, or planned project durations.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])Arguments
| Argument | Required | What it means |
|---|---|---|
start_date | Yes | The first date in the period. |
end_date | Yes | The last date in the period. |
holidays | No | A date or range of dates to exclude in addition to weekends. |
Examples
Count project workdays
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Project | Start | End | Holiday |
| 2 | Launch | 1/1/2024 | 1/8/2024 | 1/3/2024 |
=NETWORKDAYS(B2,C2,D2)Result: 5
The period contains six weekdays, and the listed Wednesday holiday reduces the result to five.
Common mistakes
Expecting NETWORKDAYS to exclude custom weekend days.
Use NETWORKDAYS.INTL when the weekend is not Saturday and Sunday.
Entering holidays as text that Sheets does not recognize as dates.
Store holiday values as dates or use DATE to construct them.