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
| Holiday | 2026 date |
|---|---|
| New Year’s Day | Thursday, January 1 |
| Martin Luther King Jr. Day | Monday, January 19 |
| Washington’s Birthday (Presidents Day) | Monday, February 16 |
| Memorial Day | Monday, May 25 |
| Juneteenth | Friday, June 19 |
| Independence Day | Friday, July 3 (observed; July 4 is a Saturday) |
| Labor Day | Monday, September 7 |
| Columbus Day | Monday, October 12 |
| Veterans Day | Wednesday, November 11 |
| Thanksgiving Day | Thursday, November 26 |
| Christmas Day | Friday, 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
| Month | 2026 | 2027 |
|---|---|---|
| January | 20 | 19 |
| February | 19 | 19 |
| March | 22 | 23 |
| April | 22 | 22 |
| May | 20 | 20 |
| June | 21 | 21 |
| July | 22 | 21 |
| August | 21 | 22 |
| September | 21 | 21 |
| October | 21 | 20 |
| November | 19 | 20 |
| December | 22 | 21 |
| Total | 250 | 249 |
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.
| Holiday | Observed date |
|---|---|
| New Year’s Day | Friday, January 1, 2027 |
| Martin Luther King Jr. Day | Monday, January 18, 2027 |
| Washington’s Birthday | Monday, February 15, 2027 |
| Memorial Day | Monday, May 31, 2027 |
| Juneteenth | Friday, June 18, 2027 |
| Independence Day | Monday, July 5, 2027 |
| Labor Day | Monday, September 6, 2027 |
| Columbus Day | Monday, October 11, 2027 |
| Veterans Day | Thursday, November 11, 2027 |
| Thanksgiving Day | Thursday, November 25, 2027 |
| Christmas Day | Friday, 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.11means Sunday only;1is 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.
Related calculators and templates
- Free Invoice Generator
- Invoice Late Fee & Interest Calculator
- Time Card Calculator with Breaks and Overtime
- Accounts Payable Tracker Template
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)”
[…] Business Days Calculator […]