Working days and excluded dates
Calendar days counted reflect your endpoint choices. Weekend exclusions are removed first; the holiday count then removes only holidays that would otherwise be working days. Unique holiday dates entered includes dates outside the counted interval, so it can exceed the holiday exclusions.
For elapsed calendar years, months, and days, use the Date Difference Calculator .
The formula
Each date in the adjusted interval is classified once. A repeated holiday entry is deduplicated, and a holiday on a weekend is already excluded. Gregorian dates are evaluated at UTC midnight, so daylight-saving clock changes do not alter the day count.
October 2026 working-day example
October 1–31, 2026 contains 31 calendar days. Including both dates and excluding Saturday and Sunday removes 9 weekend days, leaving 22 business days. Entering 2026-10-02 as a holiday removes one more day, leaving 21.
How to use this calculator
- Enter the start and end dates in chronological order.
- Choose the days your organization treats as weekends.
- Enter holiday dates, or none. Set the start and end inclusion checkboxes, then calculate.
Choose endpoints to match the question
An interval can mean all dated work shifts, or the days remaining after a starting event. Including the start date suits an attendance period; excluding it may suit a countdown. The tool exposes both endpoints independently. A same-day range counts one date only when both endpoints are included. Otherwise it is empty.
Supply the observed closure dates
Holiday dates vary by employer and location. Enter the actual date when work is closed, including any substitute closure observed after a weekend holiday. The calculator does not move a holiday automatically or determine a jurisdiction’s official calendar. Dates outside your interval are retained in the unique-input count but do not reduce business days.
Check a nonstandard workweek
A Friday–Saturday weekend or a Sunday-only weekend changes which dates qualify. Selecting no weekend exclusions treats every date as potentially working; entered holidays can still remove dates. The count is suitable for planning whole days. It does not model partial shifts, changing schedules, hours, or the rules for a statutory deadline.
Assumptions & limitations
What this calculation assumes
- Both endpoint dates are included by default.
- One selected weekend pattern applies throughout the interval; holidays are supplied by you.
What to keep in mind
- Dates must fall between 1900 and 2100, with the end on or after the start.
- At most 500 holiday entries and 6,000 characters are accepted; duplicates count once.
- No automatic public-holiday lookup, substitute-day rule, half-day schedule, or deadline eligibility calculation.
Common questions
Are both dates included?
Yes by default. Uncheck either endpoint to exclude it; the breakdown updates to match.
Does a weekend holiday subtract two days?
No. It appears in the weekend exclusions only, even if entered several times.
Can this match Excel NETWORKDAYS.INTL?
For dates after 1900, matching weekend days and holidays, and both endpoints included, the working-day count follows the same classification approach. This calculator rejects reversed date ranges instead of returning a negative count.