Count Monday 2 June through Friday 6 June 2025, including both endpoints, with a Monday–Friday workweek and Wednesday 4 June marked as a company holiday.
5 calendar days − 0 weekend days − 1 eligible holiday = 4 business days. The excluded date is Wednesday 4 June; the answer is four.
Start on Thursday 5 June 2025 and add five business days, with Monday 9 June entered as a holiday. The base is day zero: Friday is day 1, Tuesday day 2, Wednesday day 3, Thursday day 4, and Friday day 5.
The result is Friday 13 June 2025. Eight calendar dates are traversed; Saturday, Sunday, and Monday’s holiday are skipped.
Use the calculator for delivery estimates, SLA response windows, invoice terms, employee notice periods, payroll cut-offs, and project schedules. Legal or contractual rules may use different holidays, cut-off times, and endpoint conventions, so confirm the governing definition.
business days = eligible selected weekdays − applicable holidays on those weekdays
For a date range, the calculator walks through each included date, checks whether its weekday is selected, then removes an applicable public holiday or custom closure. A holiday already on a non-working day is not removed twice. For adding or subtracting, it steps one calendar date at a time from the base date and stops after the requested number of eligible days; the base date is day zero.
=NETWORKDAYS(A1,B1,H1:H5) counts Monday–Friday dates inclusively. NETWORKDAYS.INTL accepts a weekend pattern for custom schedules. =WORKDAY(A1,5,H1:H5) adds five workdays, while WORKDAY.INTL supports non-standard weekends. Spreadsheet locale and endpoint behavior should be checked before comparing results.
For Monday through Friday with no holidays, including both dates gives five business days. Excluding Monday but including Friday gives four. This calculator shows the applied rule in every result.
Calendar days include every date. Business or working days include only the weekdays selected for the relevant organization.
Public calendars cover country and sometimes regional holidays. Company shutdowns, local holidays, and one-off closures belong in the custom list.
A weekend holiday may be observed on another weekday. The observed date must exist in the selected public calendar or be added manually; the original weekend date is not double-counted.
Use the seven weekday controls for Friday–Saturday weekends, a Sunday-only weekend, shift schedules, or a four-day week.
Check whether the starting event is day zero, whether the due date itself counts, whose holiday calendar applies, and whether a deadline moves when it lands on a closure. Half-days, submission cut-off times, and emergency closures need manual review.
Reviewed and updated: 14 July 2026 · Responsible team: Starlight Tools Editorial Team
Calculations use calendar-date arithmetic at UTC midnight to avoid daylight-saving shifts. Automatic holidays come from the community-maintained Nager.Date Holiday API, which labels holiday types and available subdivision codes. This page permits automatic requests for 1975–2075 and up to 11 calendar years per calculation; actual country, year, region, and observed-date coverage depends on the provider. The last refresh time, requested years, and region are shown above each result.
For authoritative checks, consult the relevant national or regional authority, such as GOV.UK bank holidays or the U.S. Office of Personnel Management federal holiday schedule. Observance rules can depend on a worker’s schedule.
Privacy: calculations and custom closures stay in the browser. Selecting automatic holidays requests only a country code and year from Nager.Date. Creating a share link deliberately places selected settings and custom closure text in the URL.
Limitations: company closures, half-days, city or local holidays, emergency closures, court rules, filing cut-offs, and contractual definitions may require manual adjustment. This calculator is a planning aid, not legal advice.
Use Include start date and Include end date to choose each endpoint explicitly. An included endpoint counts only when it is a selected working weekday and is not an excluded holiday.
Yes, after you select a country and enter valid dates. The calculator requests the required country and calendar year from Nager.Date, then applies national and, when selected, regional public holidays.
The calculator uses the dates and holiday types supplied by Nager.Date, including observed or substitute dates when the provider includes them. Confirm important deadlines against the relevant government calendar.
A holiday on a non-working weekday is not subtracted twice and does not increase Holidays skipped. A separate observed weekday is excluded when it appears in the selected holiday calendar.
Yes. Add custom dates with the date picker or enter one ISO date per line. Custom dates stay in your browser and are combined with automatic public holidays.
Yes. Choose a preset or mark any combination of Monday through Sunday as working days. At least one weekday must remain selected.
Choose Subtract and enter a non-negative whole number. The calculator steps backward from the base date, treating the base date as day zero and skipping non-working days and applicable holidays.
It means five eligible working days under the chosen workweek and holiday settings. From a Monday, five business days may end on the following Monday when Tuesday is a holiday.
Calendar days include every date. Business days include only selected working weekdays after applicable public holidays and custom closures are removed.
No time or time zone is requested. The calculator treats each ISO date as a calendar date and uses UTC-safe arithmetic to avoid daylight-saving shifts.
No. Every selected date counts as either one full business day or zero. Adjust the result manually when an organization uses half-days or partial closures.
Use the result as a planning aid, not legal advice. Court rules, contracts, filing systems, local holidays, emergency closures, and endpoint conventions may define a business day differently.