Why this matters
Project timelines, contract delivery dates, SLA deadlines, and payroll periods all operate in business days, not calendar days. A two-week calendar span that includes a public holiday and a weekend is actually only eight working days, and miscounting by even one day can cascade into missed deadlines, penalty clauses, or incorrect pay calculations. The difference between 10 business days and 10 calendar days is often two to four days, which is significant enough to matter in professional contexts.
Holiday handling adds another layer of complexity that simple day-counting formulas miss. Different countries, regions, and even organizations observe different sets of public holidays, and these dates shift every year because many follow lunar or moveable calendars. Rather than hardcoding a fixed holiday database that will inevitably be wrong for someone, this tool lets you paste your own holiday list in YYYY-MM-DD format. The breakdown then shows you exactly how many total days were in the range, how many weekend days were excluded, how many holidays fell on non-weekend days, and the resulting net working-day count.
Working day count breakdown
| Component | Description | How It Is Counted |
|---|---|---|
| Total calendar days | All days from start to end inclusive | end - start + 1 |
| Weekend days | Saturdays and Sundays | Counted when Exclude weekends is on |
| Holidays on weekdays | Non-weekend dates in your holiday list | Only subtracted if not already a weekend |
| Net working days | Final count after all exclusions | Total - weekends - weekday holidays |
How to use it
Pick a start date and an end date — both endpoints are inclusive, so if you pick Monday and Friday with weekends excluded, the count is 5.
Toggle Exclude weekends on or off depending on whether you need Saturday and Sunday removed from the count.
Paste holiday dates into the text area, one per line in YYYY-MM-DD format (e.g., 2025-12-25).
Read the net working-day count and review the full breakdown showing total days, excluded weekends, excluded holidays, and the final result.
If you accidentally enter the start date after the end date, the tool automatically swaps them so the range always reads from earlier to later.
Testing your result
Verify with a known range: Monday January 6 through Friday January 10, 2025, with weekends excluded and no holidays, should yield exactly 5 working days. Add January 6 as a holiday and the count drops to 4. Add January 4 (a Saturday) as a holiday — it should not further reduce the count because it was already excluded as a weekend day. Test the auto-swap by entering the later date first and confirming the breakdown still calculates correctly with the dates in the right order. For a full-year calculation from January 1 through December 31, verify that the weekend count is approximately 104 (52 Saturdays and 52 Sundays, adjusted for the specific year's calendar structure).
Common mistakes
Forgetting that both endpoints are inclusive — a common off-by-one error when comparing against tools that use exclusive end dates.
Including holiday dates that fall on weekends, expecting them to further reduce the count — holidays on weekends are counted in the holiday total but not double-subtracted from the working-day total.
Using an incorrect date format for holidays — only YYYY-MM-DD is accepted, and invalid lines are flagged with a toast notification.
Assuming the tool knows your country's public holidays automatically — you must supply the exact dates yourself.
Edge cases and options
The tool handles date ranges that span multiple years without limitation, which is useful for long-term project planning and contract duration calculations. When Exclude weekends is toggled off, all days including Saturdays and Sundays count as working days, which is relevant for shift-work scheduling in industries like healthcare and hospitality that operate seven days a week. The holiday parsing is forgiving — empty lines in the holiday list are silently ignored, and malformed entries trigger a clear toast message without crashing the calculation. For dates in the southern hemisphere where weekends may differ from Saturday-Sunday, leave the weekend exclusion off and manually include all non-working days in the holiday list.
Real-world use cases
Calculating the number of business days remaining in a sprint by entering today's date and the sprint end date with the company's observed holidays.
Determining whether a contract delivery window of 30 business days falls before or after a regulatory deadline.
Computing prorated salary for a partial month by counting working days from the hire date to the pay period end.
Planning a multi-country project timeline by entering each region's specific holiday list and comparing the resulting working-day counts.
Frequently asked questions
Q: Are both endpoints inclusive?
A: Yes. If you pick Monday as the start and Friday as the end with weekends excluded, the count is 5 — both Monday and Friday are included.
Q: What if I pick start after end?
A: The tool automatically swaps them so the range always reads from earlier to later.
Q: How are holidays counted if they fall on a weekend?
A: They are counted in the parsed-holidays total but not double-subtracted from the workday count. Only non-weekend holidays reduce the workday total when weekends are excluded.
Q: What date format should I use for holidays?
A: YYYY-MM-DD (ISO 8601), e.g., 2025-12-25. Invalid lines are flagged with a toast and ignored.
Q: Does the tool know my country's public holidays?
A: No — you paste your own holiday list. Public holidays vary by country and region, so we let you supply the exact dates that apply to you.
Start using it now
Try the Workday Calculator tool. See also Week Number Calculator and Calendar Generator for related date and calendar tools.
