Business Days Calculator

For the chosen interval, business days = included calendar days − weekend days − holidays on other days. Complete weeks are counted together, then any leftover weekdays are checked. A holiday is subtracted only if it lies inside the included interval and is not already a selected weekend day.

In Count business days mode, both endpoint controls apply before weekends and holidays are removed. For the same start and end date, the result is one only if both endpoints are included and that date is a working day; otherwise it is zero. Reversed ranges produce an error rather than a negative count.

Comparing this count with Date Difference's weekday count? That tool includes the start and excludes the end by default; this tool defaults to the reverse. To match its default interval, select Include start date and clear Include end date in Count business days mode. Use Saturday–Sunday weekends and no holidays to compare the same Monday–Friday count. Other schedules or holidays can still change the total.

Offsets exclude the start and include the resulting working date. A nonzero offset starts counting in the chosen direction on the following or preceding date, without first moving the start to a weekday. An offset of zero always preserves the start. The supported whole-number offset is −3,652,058 through 3,652,058; the result must also remain within 0001-01-01 through 9999-12-31.

Business-day date range applies two positive offsets independently to the same start date, weekend schedule, and holiday list. The minimum and maximum must be whole numbers from 1 to 3,652,058, with minimum ≤ maximum; both resulting dates must stay within the supported years. Equal limits return the same date twice. The start is always excluded, even when it is a weekend or holiday. Calendar days elapsed means the date difference from the start, without including both endpoints. An invalid limit produces an error instead of a partial result.

The holiday list accepts up to 200 nonempty lines and 4,096 characters, including duplicates. Blank lines are ignored. Enter actual observed days off separately: a holiday on Sunday does not automatically make Monday a holiday. Dates outside the counted interval are accepted but do not affect the answer. There is no built-in country, stock-exchange, banking, or company calendar.

Results are exact whole days in the proleptic Gregorian calendar, including dates before its historical adoption. Leap years follow the divisible-by-4 rule with the century exception described by the U.S. Naval Observatory. Calendar dates are not converted to timestamps, so daylight-saving transitions and your device's time zone do not change the result.

Excluding selected weekends and supplied holidays is also the approach documented for Microsoft Excel's WORKDAY.INTL function. This calculator uses its own explicit input limits and endpoint choices, not Excel date serial numbers. For calendar months or years, use the Date Calculator. Check any contractual deadline rule separately: this tool does not infer special cutoffs, half days, or legal extensions.