Date formula
NETWORKDAYS in Excel and Google Sheets
Count working days between two dates, skipping weekends and holidays.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])- start_date
- First day.
- end_date
- Last day.
- holidays
- Optional range of holiday dates.
Example
| Row | A | B | C |
|---|---|---|---|
| 1 | Start | End | Working days |
| 2 | 2026-10-05 | 2026-10-16 |
C2 =NETWORKDAYS(A2,B2)
Result: 10
Counts Monday to Friday between the dates, inclusive.
Ready-to-copy formulas
Deadline after 10 working days
=WORKDAY(A2,10)
Tips
- Both start and end dates are counted.
Need the whole spreadsheet?
Start from a free template with every formula already in place. Opening a template uses no credits.