NETWORKDAYS Function
Returns the number of working days (excluding weekends and optionally holidays) between two dates. Essential for project planning and deadline calculations.
ExcelGoogle Sheets
Syntax
NETWORKDAYS(start_date, end_date, [holidays])Parameters
| Parameter | Description |
|---|---|
| start_date | The start date. |
| end_date | The end date. |
| holidays(optional) | A range of dates to exclude as holidays. |
Examples
Count working days in a project
=NETWORKDAYS("2026-01-05", "2026-01-16")Result: 10
Working days excluding holidays
=NETWORKDAYS(A1, B1, C1:C5)Data: A1 = Jan 5, B1 = Jan 16, C1:C5 has 2 holidays in range
Result: 8
Days until deadline from today
=NETWORKDAYS(TODAY(), A1)Data: A1 = a date ~3 weeks away
Result: 15
Tips & Best Practices
- •Weekends (Saturday and Sunday) are always excluded.
- •Use NETWORKDAYS.INTL for custom weekend definitions (e.g., Friday-Saturday).
- •The result includes both the start and end dates if they are working days.
Related Formulas
Need a different formula?
Describe what you need in plain English and our AI will generate the formula for you.
Try Formula Generator