Count dates using calendar days rather than local-clock elapsed hours. The start date is included in work-day enumeration and the end is excluded 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.
End must be on or after start; an equal pair yields zero unless the end is included.
Calculation notes
Understand the Work Days Calculator
Work Days Calculator validates start date, end date, include the end date, excluded holidays (yyyy-mm-dd, comma separated) before applying the displayed equation. End must be on or after start; an equal pair yields zero unless the end is included.
Formula and logic
What is the formula for the Work Days Calculator?
Work Days Calculator: work days = count(Monday–Friday dates not in the supplied holiday set). Input definitions: start = Start date; end = End date; inclusive = Include the end date; holidays = Excluded holidays (YYYY-MM-DD, comma separated). Use the selected convention throughout the calculation.
Worked example
How can I reproduce the Work Days Calculator example?
Work Days Calculator baseline input: Start date: 2026-01-01; End date: 2026-01-31; Include the end date: not selected; Excluded holidays (YYYY-MM-DD, comma separated): . Output: Work days (Monday–Friday) = 22 days. Substitute these values into the displayed equation to reproduce the result.
How to read the result
How should I interpret the Work Days Calculator result?
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 at a time and use the equation to explain the result; do not mix unit, grade-scale, time-zone or rounding conventions across comparisons.
Limits and assumptions
What limits apply to the Work Days Calculator?
End must be on or after start; an equal pair yields zero unless the end is included.
Work days exclude Saturdays, Sundays and supplied holidays only; local public holidays are not fetched automatically.
Calendar-date inputs and calculated calendar dates must stay within years 0001–9999.
Count dates using calendar days rather than local-clock elapsed hours. The start date is included in work-day enumeration and the end is excluded 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. End must be on or after start; an equal pair yields zero unless the end is included. Work days exclude Saturdays, Sundays and supplied holidays only; local public holidays are not fetched automatically. 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.