Business days calculator

Count working days between two dates, or add business days to find a deadline. Weekends and public holidays are skipped, and every holiday removed is listed.

Loading the calculator…

How business days are counted

A business day is any day in your working week that isn't a public holiday. The calculator walks the range one day at a time, so the count stays right even when a holiday falls on a weekend, when the range crosses years, or when your week isn't Monday to Friday.

When a holiday lands on a weekend

US and UK rules move weekend holidays differently. Change the year to see which weekday actually gets the day off.

2027
HolidayFalls onUS federal day offUK (E&W) day off
Independence Day (4 Jul)SundayMon 5 Jul 2027not a holiday
Christmas DaySaturdayFri 24 Dec 2027Mon 27 Dec 2027
Boxing DaySundaynot a holidayTue 28 Dec 2027

US (OPM): Saturday holidays are observed on the Friday before, Sunday holidays on the Monday after. UK: a weekend bank holiday gets a "substitute day" on the next weekday that isn't already a holiday, so a Saturday Christmas pushes Boxing Day to Tuesday.

Holiday calendar

Holidays are generated from the rules in law rather than typed in, so every year works. Sources: 5 U.S.C. § 6103 and OPM federal holiday observance rules (OPM) and Banking and Financial Dealings Act 1971 and GOV.UK bank holidays (GOV.UK).

DateHoliday
Thu 1 Jan 2026New Year's Day
Mon 19 Jan 2026Birthday of Martin Luther King, Jr.
Mon 16 Feb 2026Washington's Birthday
Mon 25 May 2026Memorial Day
Fri 19 Jun 2026Juneteenth National Independence Day
Fri 3 Jul 2026Independence Day (observed) · actual date Sat 4 Jul 2026
Mon 7 Sep 2026Labor Day
Mon 12 Oct 2026Columbus Day
Wed 11 Nov 2026Veterans Day
Thu 26 Nov 2026Thanksgiving Day
Fri 25 Dec 2026Christmas Day

Spreadsheet equivalents

  • =NETWORKDAYS(A1, B1, holidays) counts working days, both ends included.
  • =WORKDAY(A1, 10, holidays) adds 10 business days (start is day 0).
  • =NETWORKDAYS.INTL(A1, B1, "0000011") sets a custom weekend; the string marks Monday to Sunday, 1 = day off.

Questions people ask

How do I calculate business days between two dates?
Count the calendar days in the range, remove Saturdays and Sundays (or whichever days you don't work), then remove public holidays that fall on working days. The calculator does this day by day and lists every holiday it removed.
Are the start and end dates counted?
By default both are counted if they are working days, which matches Excel and Google Sheets NETWORKDAYS. Untick either box to exclude it, for example when a notice period starts the day after it is served.
How does "add business days" count?
The start date is day 0 and day 1 is the next working day. 5 business days after a Monday is the following Monday. This matches the WORKDAY function in spreadsheets.
Which holidays are included?
US: the 11 federal holidays in 5 U.S.C. § 6103, moved to the Friday or Monday when they fall on a weekend, as OPM publishes them. UK: bank holidays for England and Wales under the Banking and Financial Dealings Act 1971 with substitute days and one-off royal proclamations, as listed on GOV.UK. Scotland and Northern Ireland have different bank holidays; add them as custom days.
Can I use a Sunday–Thursday or six-day work week?
Yes. Toggle the working days to match your schedule; weekends and holidays are then skipped based on your selection.
Is Juneteenth included?
Yes, from 2021, when Juneteenth National Independence Day became a federal holiday. Years before 2021 do not include it.

Other date calculators

Date calculatorAdd or subtract years, months, weeks and days.Days between datesExact gap in days, weeks and months.Time durationHours and minutes across time zones.Days from todayThe date N days ahead or back.Days untilHow many days are left until a date.AgeExact age in years, months and days.Week numberISO 8601 week of any date.Day of year & JulianOrdinal day, YYDDD and Julian Day.Day of the weekWeekday of any date, with the method.Recurring datesEvery N days, weeks or months.Add days to a dateAdd days, with month-end rules shown.Add months to a dateAdd months: EDATE vs spill-over rules.Days to yearsConvert days, weeks, months, years.