Formula guide · Excel and Google Sheets · Updated May 13, 2026
NETWORKDAYS Formula
Use NETWORKDAYS to count working days between two dates.
Quick Answer
NETWORKDAYS counts business days between two dates, including both start and end dates when they are workdays.
Copyable Formula
=NETWORKDAYS(A2,B2,H2:H12)Syntax
=NETWORKDAYS(start_date, end_date, [holidays])Excel and Google Sheets
Worked Example
| A | B | H |
|---|---|---|
| Start | End | Holiday list |
| 2026-05-01 | 2026-05-31 | 2026-05-25 |
Result: Counts workdays in May 2026 while excluding weekends and the listed holiday.
Steps
- Enter the start and end dates.
- Add a holiday list if needed.
- Use NETWORKDAYS.INTL for custom weekends.
Common Mistakes
- Expecting it to exclude holidays without a holiday range.
- Forgetting that the count is inclusive.
- Using it for elapsed calendar days.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.