Date and time
NETWORKDAYS function playground
Counts working days (Monday to Friday) between two dates, minus holidays.
The playground runs in your browser. Nothing you type is sent anywhere.
How NETWORKDAYS works
NETWORKDAYS counts every day from start to end, including both, then removes Saturdays, Sundays and any holiday dates that fall on a weekday.
Keep holidays in a list on the sheet and point to it, so you can update them in one place.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])| Argument | What it means |
|---|---|
start_daterequired | The first day. |
end_daterequired | The last day. Both ends are counted. |
holidaysoptional | Optional range of dates to leave out, such as F2:F4. |
Examples
| Formula | What it does | Result |
|---|---|---|
=NETWORKDAYS(B2,C2,F2:F4) | Working days per task, skipping holidays. | 14 · 19 · 40 · 30 … |
=NETWORKDAYS(B2,C2) | Without the holiday list. | 15 · 20 · 40 · 30 … |
=C2-B2+1 | Calendar days, for comparison. | 19 · 26 · 54 · 40 … |
Common mistakes
Holidays as textHoliday cells must be real dates, not text that looks like a date.
Different weekendsFor weekends other than Saturday and Sunday, use NETWORKDAYS.INTL.
Related functions
Learn more
Download the example workbook (.xlsx)
The workbook has the same sample data and formulas, plus a practice sheet.