How to Use NETWORKDAYS in Excel
NETWORKDAYS counts working days between two dates. Here's the syntax, a real project-planning example, how holidays work, and the mistakes that throw off the count.
Reviewed by Griddy
Updated for current Excel and Google Sheets workflows, with examples chosen to map back to real spreadsheet tasks rather than abstract formula syntax.
NETWORKDAYS counts how many working days sit between two dates. Use it when calendar days are the wrong metric and you need an answer based on business days instead.
That makes it useful for launch planning, due-date tracking, approval windows, staffing lead time, and any other workflow where weekends should not count.
The syntax
=NETWORKDAYS(start_date, end_date, [holidays])- start_date — the first date in the range
- end_date — the last date in the range
- [holidays] — an optional range of dates to exclude in addition to weekends
By default, Excel treats Saturday and Sunday as weekends.
Basic example
If A2 contains a project kickoff date and B2 contains the target launch date:
=NETWORKDAYS(A2, B2)Excel returns the number of working days between those two dates, including both endpoints when they fall on workdays.
That is much more useful than simple date subtraction when you are planning work inside a project tracker template or a Gantt chart template.
Step-by-step project example
Say a campaign starts on 2026-04-08, needs legal review before launch, and the team wants to know how many working days are left until 2026-04-25.
Step 1. Put the start date in A2 and the end date in B2.
Step 2. Put company holidays in H2:H5.
Step 3. Use:
=NETWORKDAYS(A2, B2, H2:H5)If one of those dates in H2:H5 is a holiday, Excel removes it from the count automatically.
That gives you the working-day window the team actually has, not the calendar-day window that looks bigger than reality.
Count working days from today to a deadline
If C2 contains the deadline date and you want a live countdown based on today:
=NETWORKDAYS(TODAY(), C2, H2:H5)This is useful in execution sheets where managers want to know how many workdays remain before a deliverable slips.
Common mistakes with NETWORKDAYS
| Mistake | What happens | Fix |
|---|---|---|
| Using text that only looks like a date | Wrong count or #VALUE! | Make sure Excel is storing real dates, not text |
| Forgetting the holiday list | Count is too high | Add a holiday range as the third argument |
| Expecting custom weekends | Result looks wrong | Use NETWORKDAYS.INTL if weekends are not Saturday/Sunday |
| Comparing against raw date subtraction | Working-day count looks "too low" | Remember NETWORKDAYS excludes weekends and listed holidays |
✦ TIP
If your organization has Friday/Saturday weekends or rotating non-working days, switch to NETWORKDAYS.INTL. Standard NETWORKDAYS only understands the default weekend pattern.
NETWORKDAYS vs simple date subtraction
If you subtract dates directly:
=B2-A2Excel gives you calendar days.
If you use:
=NETWORKDAYS(A2, B2, H2:H5)Excel gives you working days.
That distinction matters in operating sheets. A launch plan, staffing schedule, or approval workflow usually cares about days people can actually work, not every date on the calendar.
When to use NETWORKDAYS
NETWORKDAYS is strongest when the sheet needs to answer questions like:
- how many workdays remain before launch?
- how many business days did this task stay open?
- how much working time is left before the next milestone?
That is why it fits naturally inside employee schedule templates, timeline sheets, and project trackers.
The Griddy way
NETWORKDAYS is simple once the ranges are set up, but people still lose time wiring holidays, deciding which date to anchor from, and checking whether the count is off because a date is stored as text.
"Count the business days between kickoff and launch, exclude our holiday list, and show the result in the timeline summary"
Griddy can write the formula against your real columns and place the result where the team will actually review it.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Use business-day math in live planning sheets
NETWORKDAYS is most useful when plans need realistic working-day counts instead of naive calendar-day math that ignores weekends and holidays.
Gantt Chart
Plan project phases, owners, and milestones on a 12-week timeline. Colour-coded bars make schedules easy to scan in Excel, Google Sheets, or Griddy.
Gantt Chart for Product Launches
Plan launch milestones, owners, dependencies, and timing in one free Gantt chart spreadsheet built for product launches and release work.
Gantt Chart for Agencies
Plan agency timelines, client phases, approvals, and launch milestones in one free Gantt chart spreadsheet for service delivery teams.
Project Tracker
Track tasks, owners, priorities, due dates, and blockers in one delivery board. Group work by stream, review progress, and keep next steps visible.
Project Tracker for Marketing Teams
Track campaign work, owners, deadlines, approvals, and blockers in one free marketing project tracker spreadsheet for Excel and Google Sheets.
Project Tracker for Client Work
Track client deliverables, owners, due dates, approvals, and blockers in one free project tracker spreadsheet built for service teams.
Employee Schedule
Plan a weekly staff rota with day-by-day shifts, weekly hours, overtime flags, and a manager snapshot block. Free template for teams, shops, and clinics.