Work Days Calculator
Count Monday–Friday dates after excluding supplied holidays. Include the start when it is an eligible work day; exclude the end unless the inclusive option is checked.
- Explicit formulas and worked examples
- Check your inputs, then calculate
- Data is calculated in this browser only
Check the stated input format, calculation convention and limits before using the result.
Check the example inputs, then calculate. Your values stay in this browser.
The end must be on or after the start. An included date counts only if it is Monday–Friday and not an entered holiday.
Understand the Work Days Calculator
Choose the right record before calculating
Use the selected endpoint policy and supplied holiday dates with the stated Monday-through-Friday rule. A generic business-day count is not a universal holiday calendar. Keep the exception list with the result, and do not subtract a holiday twice when it already falls on an excluded weekend.
Content and calculation reviewed:
Understand the calculation
How to use it and the math behind it
Four steps to check your inputs and results
- Count Monday–Friday dates after excluding supplied holidays. Include the start when it is an eligible work day; exclude the end unless the inclusive option is checked.
- Enter Start date, End date, Include the end date, Excluded holidays (YYYY-MM-DD, comma separated) in the stated format. Baseline values are for reproduction.
- Check the output unit and convention: Read work days (monday–friday) with its stated unit and convention. The default example and the independent worked scenario use different inputs, so compare the assumptions before comparing the numbers.
- Change one input and compare the result. The end must be on or after the start. An included date counts only if it is Monday–Friday and not an entered holiday. Only Saturdays, Sundays and supplied holidays are excluded; local public or substitute holidays must be entered manually. Calendar-date inputs and calculated calendar dates must stay within years 0001–9999.
Work Days Calculator: calendar conventions
Count eligible dates, not total days minus a rough weekend estimate. January 5–12, 2026 with the end excluded contains five Monday–Friday dates. Excluding January 5 as a supplied holiday leaves four. Duplicate holiday entries are removed and weekend holidays do not subtract an extra weekday. Local holidays or substitute days must be entered explicitly.
work days = count(Monday–Friday dates not in the supplied holiday set)
The detailed guide adds variable definitions, a reproducible example, a practice question and model limitations.
Questions before you calculate
Are holidays preloaded for every country?
No. Supply the relevant dates.
Does a weekend holiday subtract twice?
No. A date already excluded by weekday rules should not be removed again.
Do endpoint settings affect weekdays?
Yes. They determine whether boundary date labels count.
Can this represent a Saturday work schedule?
The stated Monday–Friday model needs a different explicit schedule to represent that workplace.
Does this automatically roll a deadline?
No. Deadline rollover is a separate policy.
From question to result