How to Calculate Workdays
Last updated: 2026-09-06
⚡ Quick Answer
NETWORKDAYS calculates the exact number of whole working days between two dates.
=NETWORKDAYS(Start_Date, End_Date, Holidays_Range)📊 Visual Demo
HOME · INSERT · FORMULAS · DATA
fx =NETWORKDAYS(Start_Date, End_Date, Holidays_Range)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | 1 | 2026-03-01 | 2026-03-31 | =NETWORKDAYS(B2, C2) | 22 Workdays |
| 2 | 2 | Project Span | March 2026 | Holidays Excluded | Accurate Timeline |
| 3 | 3 | Planning | Resource Load | Evaluated | Schedule Ready |
🧠 Deep Dive
NETWORKDAYS calculates the exact number of whole working days between two dates.
Key Insights
- Excel dates are serial numbers (Jan 1 1900 = 1).
- TODAY() and NOW() are volatile functions.
Common Mistakes
- Subtracting text-dates resulting in #VALUE!.
- Using TODAY() without freezing history.
Pro Tips
- Paste-special values for snapshots.
- Store holidays in a named range.
FAQ
What does this formula do in plain English?
NETWORKDAYS calculates the exact number of whole working days between two dates.
Why is my formula not working?
Subtracting text-dates resulting in #VALUE!.
Does this work in Google Sheets?
Yes, this syntax is fully compatible with Google Sheets.
What is the most common mistake?
Using TODAY() without freezing history.
Related Guides
How to Extract Date ComponentsHow to Calculate Date IntervalsHow to Use TODAY and NOWExcel Error Hub
Need Complete Playbooks?
Download our verified manuals covering ERP Cleanup and Modeling.
Explore Playbook Series (From ₹199)