Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to count weekdays between two dates in Excel and Google Sheets
Excel & Google Sheets
=NETWORKDAYS(A2,B2)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your start date in one cell (e.g. A2) and end date in another (B2).
- 2In the output cell, type =NETWORKDAYS(A2,B2).
- 3Press Enter. The result includes both the start and end dates if they are weekdays.
- 4To exclude holidays, add a third argument: =NETWORKDAYS(A2,B2,D2:D5) where D2:D5 lists holiday dates.
- 5For a custom weekend (e.g. Friday–Saturday), use NETWORKDAYS.INTL: =NETWORKDAYS.INTL(A2,B2,"0000011").
Tips
- NETWORKDAYS includes both the start and end date in the count.
- Dates must be stored as actual date values, not text strings — use DATEVALUE() if needed.
- NETWORKDAYS.INTL (Excel 2010+, Google Sheets) lets you define custom weekend days.
- Subtracting 1 from the result excludes the start date from the count.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Does NETWORKDAYS count the start and end date?
Yes, both dates are included if they are weekdays. Subtract 1 if you want to exclude the start date.
How do I handle different weekend conventions (e.g. Friday–Saturday)?
Use NETWORKDAYS.INTL with a weekend string like "0000011" where 1s mark weekend days starting from Monday.