Tools

Business days calculator

Working days between two dates, without weekends and US or UK holidays. Nothing you type leaves your browser.

Calculate
Weekends are Saturday and Sunday. Dates are read on your own calendar.
Working days
0days
Pick two dates

Your employer or state may observe different holidays. Check the days that matter with them.

How to use the business days calculator

  1. Choose what to work out. Between two dates counts the working days in a date range. Add working days finds the date a number of working days after (or before) a start date, which is handy for deadlines such as "within 10 business days".
  2. Pick the public holidays to leave out: none, US federal holidays, or the bank holidays of England and Wales, Scotland or Northern Ireland.
  3. Enter the dates. The result updates as you type, with the holidays that fell in the range listed underneath. Use Copy result to paste the answer into an email or a spreadsheet.

How working days are counted

A working day here is any Monday to Friday that is not a public holiday on the list you chose. The calculator works it out like this:

Working days = calendar days in the range, minus Saturdays and Sundays, minus holidays that fall on a weekday.

The start date is always counted. The end date is counted too while Count the end date as well is ticked, which is the usual way to count "Monday to Friday is 5 working days". Untick it if you want the days up to the end date, for example when the end date is the day something is due back.

Example: December 2026, from Tuesday, December 1 to Thursday, December 31, both dates counted.

HolidaysCalendar daysWeekend daysHolidaysWorking days
None318023
US federal (Christmas Day, Friday 25th)318122
England and Wales (Christmas Day, Boxing Day moved to Monday 28th)318221

With the end date not counted, each working days figure is one lower, because December 31, 2026 is a Thursday, a working day.

How many business days are in 2026?

2026 has 261 weekdays (Monday to Friday). Taking off the US federal holidays leaves 250 business days. Taking off the bank holidays leaves 253 working days in England and Wales, 251 in Scotland and 251 in Northern Ireland. Month by month, with both the first and last day of each month counted (weekdays only, then weekdays minus US federal holidays, then weekdays minus England and Wales bank holidays):

2026WeekdaysUS business daysEngland and Wales
January222021
February201920
March222222
April222220
May212019
June222122
July232223
August212120
September222122
October222122
November211921
December232221
Whole year261250253

February and November have the fewest US business days (19 each): February is short and has Washington's Birthday, and in November Veterans Day and Thanksgiving both fall on weekdays. In England and Wales, May is lowest (19), with two bank holidays. Independence Day 2026 is a Saturday, so the US figure for July takes off the observed day, Friday, July 3.

2027: 261 weekdays; 249 business days after US federal holidays (twelve days off, because New Year's Day 2028 is observed on Friday, December 31, 2027), and 253 after England and Wales bank holidays.

Your own employer may close on other days too, such as a state holiday or the day after Thanksgiving, so take those off as well. For any other range, enter its first and last day above.

How many days until a date, without weekends

To count the business days until a deadline or an event, use Between two dates:

  1. Enter today (or the day you start counting) as the Start date. The start date is counted, so if today is already over, start from tomorrow.
  2. Enter the target date as the End date. Leave Count the end date as well ticked if that day is a working day you can still use; untick it to count only the days before it.
  3. Choose None, weekends only for a plain count without weekends, or a holiday list to take those days off too.

Example: how many days until Wednesday, November 25, 2026 without weekends, counting from Monday, November 2, 2026.

HolidaysEnd date countedEnd date not counted
None, weekends only1817
US federal (Veterans Day, November 11)1716

To go the other way, from a number of working days to a date (a working date calculator), switch to Add working days, as shown further down this page.

US federal holidays and observed days

The US list is the 11 legal public holidays in federal law, 5 U.S.C. 6103: New Year's Day (January 1), Birthday of Martin Luther King, Jr. ("the third Monday in January"), Washington's Birthday (the third Monday in February), Memorial Day ("the last Monday in May"), Juneteenth National Independence Day (June 19), Independence Day (July 4), Labor Day (the first Monday in September), Columbus Day (the second Monday in October), Veterans Day (November 11), Thanksgiving Day ("the fourth Thursday in November") and Christmas Day (December 25).

When a fixed-date holiday lands on a weekend, the day off moves. The Office of Personnel Management puts it this way:

"If a holiday falls on a Saturday, for most Federal employees, the preceding Friday will be treated as a holiday for pay and leave purposes. If a holiday falls on a Sunday, for most Federal employees, the following Monday will be treated as a holiday..."US Office of Personnel Management, Federal Holidays

So July 4, 2026 is a Saturday and Friday, July 3 is the day off. In 2027, July 4 is a Sunday and Monday, July 5 is off. New Year's Day 2028 is a Saturday, so it is observed on Friday, December 31, 2027, which gives 2027 twelve federal days off instead of eleven. The calculator takes off the observed day and marks it "(observed)".

Holidays are worked out by these rules for any year from 2021, when Juneteenth was added to the list. For earlier dates only weekends are taken off, and the calculator says so. These are federal holidays: banks, states and private employers may close on different days, so check with them if a deadline depends on it.

UK bank holidays

England and Wales, Scotland and Northern Ireland each have their own bank holidays. Scotland has 2 January and St Andrew's Day, and in 2026 an extra World Cup bank holiday on 15 June. Northern Ireland has St Patrick's Day and the Battle of the Boyne. The dates come straight from GOV.UK's official list, which currently runs from 2019 to 2028. For a year outside that range the calculator takes off weekends only and shows a note.

When a bank holiday falls at a weekend, GOV.UK says "a 'substitute' weekday becomes a bank holiday, normally the following Monday." Boxing Day 2026 is a Saturday, so Monday 28 December is the bank holiday instead.

A bank holiday is not automatically a day off for everyone: GOV.UK notes that "Your employer does not have to give you paid leave on bank or public holidays." If you work them, count the days yourself or choose None, weekends only.

NETWORKDAYS and WORKDAY in Excel and Google Sheets

To count workdays in a spreadsheet, Excel and Google Sheets have the same three functions. With the start date in A2, the end date in B2 and your holiday dates in H2:H20:

FormulaWhat it givesSame as this calculator
=NETWORKDAYS(A2,B2,H2:H20)Working days between two dates, Saturday and Sunday offBetween two dates, end date counted
=NETWORKDAYS.INTL(A2,B2,1,H2:H20)The same, with the weekend days you choose (1 is Saturday and Sunday)Between two dates, end date counted
=WORKDAY(A2,10,H2:H20)The date 10 working days after A2Add working days

NETWORKDAYS counts both the start date and the end date. Microsoft describes it as returning "the number of whole working days between start_date and end_date", and its example shows the dates are included: October 1, 2012 to March 1, 2013 gives 110. This calculator also gives 110 for those dates with Count the end date as well ticked, and 109 with it unticked. Google Sheets says NETWORKDAYS "calculates the number of work days between two dates" and that it "only treats Saturday and Sunday as the weekend".

WORKDAY does not count the start date, just like Add working days here. Microsoft's example, 151 workdays from October 1, 2008 with no holidays, gives April 30, 2009, and so does this calculator. For days, "a negative value yields a past date". WORKDAY returns a date serial number, so format the cell as a date.

NETWORKDAYS.INTL takes a weekend code or a string. Microsoft: "each character in the string represents a day of the week, starting with Monday. 1 represents a non-workday and 0 represents a workday", so "0000011" is a Saturday and Sunday weekend and code 7 is "Friday, Saturday". This calculator always uses a Saturday and Sunday weekend. In a spreadsheet, only the holiday dates you list are skipped; the holiday lists here fill them in for you.

Adding working days to a date

To find a date a number of working days ahead, the calculator steps forward one day at a time from the start date, skipping weekends and holidays, until it has counted that many working days. The start date itself is not counted, so 1 working day after a Friday is the following Monday. Choose Before it to count backwards instead.

Example: 10 working days after Friday, December 18, 2026.

HolidaysHolidays skippedResult
US federalChristmas Day, New Year's DayTuesday, January 5, 2027
England and WalesChristmas Day, Boxing Day (substitute), New Year's DayWednesday, January 6, 2027

Questions and answers

Does the business days count include the start and end dates?

The start date is always counted. The end date is counted while "Count the end date as well" is ticked, so Monday to Friday of one week is 5 working days. Untick it to count the days up to, but not including, the end date.

How many working days are there in 2026?

There are 261 weekdays in 2026. Taking off US federal holidays leaves 250 working days. Taking off England and Wales bank holidays leaves 253; Scotland and Northern Ireland have 251 each.

What happens when a holiday falls on a weekend?

For US federal holidays, a Saturday holiday is taken on the Friday before and a Sunday holiday on the Monday after. UK bank holidays get a substitute weekday, normally the following Monday. The calculator takes off the day people actually have off.

Can I use it for a working days calculation in the UK?

Yes. Choose the bank holidays for England and Wales, Scotland or Northern Ireland. If your browser is set to UK English, England and Wales is chosen for you.

Does it include state holidays or holidays like Good Friday in the US?

No. The US option uses the 11 federal holidays only. If your office also closes on a state holiday or another day, take those days off the result yourself.

Sources

Checked on 7 October 2026. If a rule has changed, please tell us.

More dates tools

All dates tools