Quick Answer & Formula
Excel
Sheets
Beginner
=NETWORKDAYS.INTL(start_date, end_date, 1, holidays_range) To calculate working days between two dates excluding weekends and US holidays: =NETWORKDAYS.INTL(StartDate, EndDate, 1, Holidays_Range). To add 10 business days to a start date: =WORKDAY.INTL(StartDate, 10, 1, Holidays_Range).
How to Calculate Business Days in Excel (Excluding Weekends & Holidays)
Measuring Turnaround Time (TAT), Customer SLA Compliance, and Sprint Milestones requires counting only legitimate business working days.
1. Calculating Elapsed Working Days
=NETWORKDAYS.INTL(A2, B2, 1, $H$2:$H$12)| Parameter | Cell | Example Value | Description |
|---|---|---|---|
| Project Kickoff | A2 | 09/01/2026 | Start Date |
| Project Delivery | B2 | 09/30/2026 | End Date |
| US Labor Day Holiday | H2 | 09/07/2026 | Holiday exclusion |
| Working Days Result | C2 | 21 days | Skips 8 weekend days + 1 holiday |
2. Calculating a Future Due Date (Add N Business Days)
To find the exact deadline 15 business days from today:
=WORKDAY.INTL(TODAY(), 15, 1, $H$2:$H$12)(Format the result cell as Short Date)
?
Frequently Asked Questions
How do I calculate business days for a 4-day or 6-day workweek?
Change the weekend argument in NETWORKDAYS.INTL (e.g. 11 for Sunday-only weekend, or "0000111" for custom work schedules).