Business Days Calculator (US Federal Holidays Included)

Invoice terms, shipping promises, notice periods and payroll deadlines often run on business days, not calendar days. This free calculator counts the working days between two dates, skipping weekends and US federal holidays (using their observed dates).

Business days calculator

Pick a start and end date. By default the start date isn’t counted, which is how most deadlines work.

When you’re done, use the buttons under the result to print or save it as a PDF, download it for Excel, Word or CSV, copy a share link or email it. Your numbers stay in your browser.

How the count works

Business days = Calendar days - Weekend days - Weekday federal holidays
Observed holidays: a Saturday holiday is observed on Friday,
                   a Sunday holiday on Monday

Worked example

From Monday, November 2 to Thursday, December 31, 2026 there are 59 calendar days (not counting the start date). Take away 16 weekend days and 3 federal holidays (Veterans Day, Thanksgiving and Christmas) and you get 40 business days.

US federal holidays in 2026

Holiday2026 date
New Year’s DayThursday, January 1
Martin Luther King Jr. DayMonday, January 19
Washington’s Birthday (Presidents Day)Monday, February 16
Memorial DayMonday, May 25
JuneteenthFriday, June 19
Independence DayFriday, July 3 (observed; July 4 is a Saturday)
Labor DayMonday, September 7
Columbus DayMonday, October 12
Veterans DayWednesday, November 11
Thanksgiving DayThursday, November 26
Christmas DayFriday, December 25

Banks follow the Federal Reserve holiday schedule, which is close to the federal list. States, and many private employers, also close on other days, so check local calendars for critical deadlines.

Where business days matter

  • Payment terms: “Net 30” usually means 30 calendar days, but some contracts use business days. Read the wording.
  • Bank transfers: ACH and wire transfers only settle on banking days.
  • Payroll: if payday falls on a holiday, most employers pay the business day before.

For a full view of cash coming in and going out week by week, try our 13-week cash flow forecast template.

Business days per month in 2026 and 2027

Month20262027
January2019
February1919
March2223
April2222
May2020
June2121
July2221
August2122
September2121
October2120
November1920
December2221
Total250249
Weekdays minus US federal holidays (observed dates).

US federal holidays in 2027

When a holiday falls on a Saturday, federal offices observe it on the Friday before; when it falls on a Sunday, on the Monday after.

HolidayObserved date
New Year’s DayFriday, January 1, 2027
Martin Luther King Jr. DayMonday, January 18, 2027
Washington’s BirthdayMonday, February 15, 2027
Memorial DayMonday, May 31, 2027
JuneteenthFriday, June 18, 2027
Independence DayMonday, July 5, 2027
Labor DayMonday, September 6, 2027
Columbus DayMonday, October 11, 2027
Veterans DayThursday, November 11, 2027
Thanksgiving DayThursday, November 25, 2027
Christmas DayFriday, December 24, 2027
New Year’s Day (observed, for 2028)Friday, December 31, 2027

How to count business days in Excel and Google Sheets

Excel and Google Sheets have built-in functions for business days. Put your holiday dates in a range (for example H2:H12) and refer to it:

  • =NETWORKDAYS(A2, B2, H2:H12) counts the business days between two dates, including both the start and end date.
  • =WORKDAY(A2, 10, H2:H12) returns the date 10 business days after the start date (the start date itself isn’t counted).
  • =NETWORKDAYS.INTL(A2, B2, 11, H2:H12) lets you change the weekend. 11 means Sunday only; 1 is the normal Saturday–Sunday weekend.

If you leave out the holiday range, these functions only skip weekends, which is the most common reason spreadsheet deadlines come out a day or two early.

Example: an invoice due in 10 business days

An invoice is dated Friday, November 20, 2026 with “payment due in 10 business days”. Thanksgiving (Thursday, November 26, 2026) falls inside that period, so it is skipped:

  • Business days 1–3: Mon Nov 23, Tue Nov 24, Wed Nov 25
  • Thu Nov 26: Thanksgiving, not counted
  • Business days 4–9: Fri Nov 27, Mon Nov 30, Tue Dec 1, Wed Dec 2, Thu Dec 3, Fri Dec 4
  • Business day 10: Monday, December 7, 2026

“10 calendar days” would have been Monday, November 30, a full week earlier. That difference is why contracts and invoices should always say which kind of day they mean. To work out interest once a payment is late, use the late fee calculator; to track all your due dates, the accounts payable tracker.

Federal holidays vs. bank holidays

US banks and the Federal Reserve close on the same 11 federal holidays this calculator uses. One difference: when a holiday falls on a Saturday, federal offices close on the Friday before, but the Federal Reserve stays open that Friday. So a bank transfer may still go through on a Friday that is a federal holiday. Some states also have their own holidays (for example the day after Thanksgiving in several states), so check your state calendar for state deadlines.

FAQ

Is Juneteenth a business day?

No. Juneteenth (June 19) has been a US federal holiday since 2021, so federal offices and banks are closed and the calculator skips it.

Is the day after Thanksgiving a business day?

For federal purposes, yes: it isn’t a federal holiday. Many private businesses and some states give the day off, though, so check the other party’s calendar if a deadline depends on it.

Are weekends business days?

No. Business days are Monday to Friday, excluding public holidays.

Does the calculator include the end date?

Yes, the end date is counted if it is a business day. You can choose whether to count the start date.

What happens when a holiday falls on a weekend?

For federal holidays, a Saturday holiday is observed on the Friday before and a Sunday holiday on the Monday after. The calculator uses those observed dates.

How many business days are in a year?

Usually about 250 to 251 in the US: around 261 weekdays minus 10 or 11 federal holidays that fall on weekdays.

How many business days are in 2027?

249 business days, counting Monday to Friday and excluding the observed US federal holidays. Banks and private employers may follow a slightly different list.

Why is December 31, 2027 a holiday?

January 1, 2028 falls on a Saturday, so the federal New Year’s Day holiday is observed on Friday, December 31, 2027.

This calculator is for general information and planning. It isn’t tax, legal, accounting or financial advice. For your own situation, talk to a qualified professional.

Comments

One response to “Business Days Calculator (US Federal Holidays Included)”