Business Days Between

Count weekdays in a half-open date range, optionally subtracting supplied holidays.

Description

Count weekdays in a half-open date range, optionally subtracting supplied holidays.

Business Days Between: Count weekdays in a half-open date range, optionally subtracting supplied holidays.

When to use Business Days Between

Use this calendar calculation when dates follow the stated calendar and you need a reproducible boundary, interval, ordinal, week, or classification result.

Start date
Inclusive lower bound.
End date
Exclusive upper bound.
Holidays
Holidays to subtract on weekdays.

How Business Days Between works

Count weekdays in a half-open date range, optionally subtracting supplied holidays. The tool evaluates the supplied inputs together and returns the named outputs below; it does not infer omitted operating conditions or change the units shown.1

Business days (days)
Weekdays remaining after holidays.
Total days (days)
Calendar days in the half-open range.
Holidays applied
Holidays applied on weekdays.

Limitations and assumptions

  • Calendar dates are not elapsed-time instants by themselves. Time zones, daylight-saving transitions, locale-specific week rules, inclusive endpoints, holidays, historical calendar reforms, and proleptic-calendar assumptions can change an apparently simple result.
  • Use finite inputs in the displayed units and preserve more precision than the final presentation requires. Independently verify safety-critical, financial, compliance, or production decisions.

Alternative or Complementary approaches

Store instants with an explicit time zone when time of day matters, and document whether interval endpoints are inclusive. Supply a jurisdiction-specific holiday calendar for business-day decisions.

References

  1. Business day — Wikipedia contributors

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies