How to Calculate a Project Deadline Excluding Weekends
Ever missed a deadline because you forgot to skip weekends? It happens to the best of us. Calculating business-day deadlines is trickier than it looks, but once you know the rules, it’s straightforward.
To calculate a project deadline excluding weekends, count business days from the start date, also skip federal holidays, and match Excel’s NETWORKDAYS convention for inclusive counting.
Step-by-step method
- Pick the start date. This is day 1 of the count.
- Count forward N business days. A business day is Monday through Friday.
- Skip Saturdays and Sundays. They don’t advance the count.
- Skip federal holidays for “US business days.” When a holiday falls on a weekend, skip the observed date (for example, July 4, 2026 falls on Saturday and is observed Friday, July 3).
- The Nth business day is the deadline.
The start date is included as day 1. This matches how most project managers and contract language interpret “N business days from start.”
Worked example: 15 business days from January 5, 2026
A project starts Monday, January 5, 2026 with a 15-business-day deadline:
- January 5 (Mon) — day 1
- January 6, 7, 8, 9 — days 2-5
- January 10-11 — weekend, skipped
- January 12, 13, 14, 15, 16 — days 6-10
- January 17-18 — weekend, skipped
- January 19 — MLK Day, skipped
- January 20, 21, 22, 23 — days 11-14
- January 24-25 — weekend, skipped
- January 26 (Mon) — day 15, the deadline
Three weekends and one federal holiday get skipped along the way. Without the MLK Day skip, the deadline would land on Friday, January 23.
NETWORKDAYS vs WORKDAY in Excel and Google Sheets
The two functions count differently, and mixing them up is the most common spreadsheet error in deadline math:
- NETWORKDAYS(start, end, [holidays]) returns the number of business days between two dates, counting both endpoints inclusively.
NETWORKDAYS("2026-01-05", "2026-01-26", holidays)= 15. - WORKDAY(start, days, [holidays]) returns a date N working days after the start, counting the start as day 0 (exclusive).
WORKDAY("2026-01-05", 15, holidays)= January 27, 2026 — one day later than the inclusive count.
If your contract says “15 business days from January 5,” NETWORKDAYS (inclusive) gives January 26 and WORKDAY (exclusive) gives January 27. Pick the function that matches the contract’s intent and document it.
Actually, I once had a client who missed a critical deadline because their spreadsheet used WORKDAY instead of NETWORKDAYS. They were off by one day, and it cost them a major client. Always double-check which function you’re using.
Business days vs calendar days in contracts
SLAs and contracts must specify the unit, because the gap is large:
- 15 calendar days from January 5 = January 20 (every day counts).
- 15 business days from January 5 = January 26 (weekends and MLK Day skipped).
That’s a 6-day difference on a 15-day commitment. For a 30-day SLA the gap can stretch to 8 or 9 days. Default language should be “business days” for any labor-based commitment, with the specific holidays to skip listed in an appendix.
Multi-month planning
When a deadline crosses month boundaries, count business days per month and sum them, because each month has a different weekend and holiday pattern:
- January 2026: 20 work days
- February 2026: 19 work days
- March 2026: 22 work days
A 50-business-day project starting January 5, 2026 finishes partway through March, not on a flat 10-week calendar estimate. Always pull the holiday list for every month the project touches.
Common mistakes to avoid
- Using WORKDAY when the contract means inclusive counting (off by one day)
- Forgetting to add the 2026 holiday list as the
[holidays]argument - Counting the start date as day 0 in one tool and day 1 in another
- Assuming every month has 22 business days (February and November 2026 have 19)
Does this mean you need to be a spreadsheet expert to calculate deadlines? Not at all — just use the right tool.
For exact date math with the 2026 federal holiday calendar baked in, use the Project Deadline Countdown Calculator and review the working-day logic in our guide to how to estimate a project deadline.
