Calculate Business Days Excluding Holidays

When a deadline is expressed in business days, most people know to skip weekends. What many miss is the second part of the calculation: public holidays. A business day excluding holidays calculation gives you the true number of working days in any period — not just weekdays, but the weekdays when institutions and businesses are actually open and operating.

Getting this right matters in legal deadlines, financial transactions, payroll periods, and shipping timelines where a single missed holiday can shift a deadline by a day and create real consequences. This guide explains exactly how to calculate business days excluding holidays, which holidays apply in different contexts, and how a workday calculator excluding weekends and holidays gives you the most accurate result.

Why Holiday Exclusion Matters in Business Day Calculations

A standard business day count excludes weekends automatically. But a weekend exclusion alone is not always enough. When public holidays fall on weekdays within your calculation range, they reduce the actual number of working days below what a weekend-only exclusion would show.

For example, a date range from January 12 to January 30, 2026, contains 19 calendar days and 4 weekend days, giving 15 preliminary business days using weekend exclusion alone. But Martin Luther King Jr. Day falls on Monday, January 19, 2026, which is a weekday within this range. Excluding this holiday reduces the working day count to 14 business days.

Missing that one holiday gives you a business day count that is one day too high and a deadline that is one day too early. In legal filings, payroll processing, and contract deadlines, one day matters.

What Is a Business Day Excluding Holidays?

A business day, excluding holidays, is any weekday, Monday through Friday, that is not a publicly recognised holiday in the relevant jurisdiction. It is the most precise definition of a working day because it accounts for both the standard weekend exclusion and the closure of institutions on public holidays.

The holidays that are excluded depend on three factors: the country or jurisdiction governing the deadline, the industry or institution involved, and, in some cases, the specific terms of a contract or agreement.

A holiday business day calculator performs the full three-part calculation automatically: total calendar days minus weekend days minus weekday holidays equals the correct business day count.

Which Holidays Count as Non-Business Days?

Not every holiday automatically reduces a business day count. Understanding which holidays apply and how to handle holidays that fall on weekends is essential for accurate calculation.

National and Federal Holidays

National or federal holidays are the most commonly excluded in business day calculations. In the United States, there are 11 recognised federal holidays. In the United Kingdom, there are 8 bank holidays in England and Wales. In Canada, the number of national holidays varies by province. These are the holidays most commonly referenced when contracts, legal documents, and financial agreements specify business days.

US Federal Holidays in 2026

Here is the complete list of US federal holidays in 2026 and the day of the week each falls on, which determines whether it reduces a business day count.

In 2026, Independence Day falls on a Saturday. The observed holiday has been moved to Friday, July 3. A properly configured holiday business day calculator accounts for observed dates rather than just the nominal holiday date.

Holidays That Fall on Weekends

A holiday that falls on a Saturday or Sunday is not subtracted separately from a business day count because that day is already excluded as a weekend day. However, many jurisdictions observe the holiday on the nearest weekday instead. In the United States, a federal holiday falling on Saturday is observed on Friday, and one falling on Sunday is observed on Monday. A workday calculator that supports observed holiday rules accounts for this automatically.

State and Regional Holidays

Beyond national holidays, individual states, provinces, and regions may observe additional non-working days. For calculations involving state courts, state government agencies, or businesses that follow state holiday calendars, these regional holidays may also need to be excluded. Always check the relevant jurisdiction’s holiday calendar when calculating business days for legal or official purposes.

Company-Specific Holidays

Some businesses observe additional non-working days beyond the national and regional calendar. Company-wide closure days, industry-specific observances, and additional holiday allowances can reduce the working day count further. For internal project planning and payroll calculations, entering company-specific holidays into your business day calculation gives a more accurate result than using the national calendar alone.

How to Calculate Business Days Excluding Holidays — Step by Step

Here is the complete manual method for calculating business days with holiday exclusion.

Step One: Count Total Calendar Days

Count every day in your date range from the start date to the end date. Include both dates or exclude the start date depending on the convention that applies to your specific context.

Step Two: Subtract Weekend Days

Count every Saturday and Sunday within the range and subtract them from the total calendar days. For every complete week in the range, there are 2 weekend days. For partial weeks at the start and end of the range, check individually whether a Saturday or Sunday falls within the period.

Step Three: Identify Weekday Holidays in the Range

List all public holidays that fall within your date range. Identify which of these holidays fall on weekdays, Monday through Friday. Only weekday holidays reduce the business day count. Holidays that fall on Saturday or Sunday are already excluded as weekend days and should not be subtracted again.

If a holiday is observed on a different day from its nominal date, use the observed date. For example, if a holiday falls on Saturday and is observed on Friday, the Friday is the day to exclude, not the Saturday.

Step Four: Subtract Weekday Holidays

Subtract the number of weekday holidays identified in Step Three from the preliminary business day count calculated in Steps One and Two.

Step Five: Confirm the Result

The final number is your true business day count for the period, reflecting both the exclusion of weekends and the exclusion of applicable holidays.

Business Days Excluding Holidays — Detailed Examples

Here are three complete examples showing the holiday exclusion calculation in practice.

Example One: January Range with One Federal Holiday

Start date: January 12, 2026, Monday. End date: January 30, 2026, Friday.

Step one: Total calendar days from January 12 to January 30 inclusive equals 19 days.

Step two: Weekend days within the range. January 17 Saturday and January 18 Sunday. January 24 Saturday and January 25 Sunday. Total weekend days: 4.

Preliminary business days: 19 minus 4 equals 15 days.

Step three: Martin Luther King Jr. Day falls on Monday, January 19, 2026. This is a weekday within the range. Weekday holidays: 1.

Step four: 15 minus 1 equals 14 business days.

Result: 14 business days excluding the federal holiday, compared to 15 without holiday exclusion.

Example Two: November Range with Two Federal Holidays

Start date: November 2, 2026, Monday. End date: November 30, 2026, Monday.

Step one: Total calendar days: 29 days.

Step two: Weekend days: November 7 to 8, November 14 to 15, November 21 to 22, November 28 to 29. Total: 8 weekend days.

Preliminary business days: 29 minus 8 equals 21 days.

Step three: Veterans Day falls on Wednesday, November 11, 2026. Thanksgiving falls on Thursday, November 26, 2026. Both are weekdays within the range. Weekday holidays: 2.

Step four: 21 minus 2 equals 19 business days.

Result: 19 business days excluding federal holidays, compared to 21 without holiday exclusion.

Example Three: Year-End Range with Christmas

Start date: December 14, 2026, Monday. End date: December 31, 2026, Thursday.

Step one: Total calendar days: 18 days.

Step two: December 19, Saturday and December 20, Sunday. December 26 Saturday and December 27 Sunday. Total: 4 weekend days.

Preliminary business days: 18 minus 4 equals 14 days.

Step three: Christmas Day falls on a Friday, December 25, 2026. This is a weekday within the range. Weekday holidays: 1.

Step four: 14 minus 1 equals 13 business days.

Result: 13 business days excluding Christmas, compared to 14 without holiday exclusion.

Holiday Exclusion by Industry

Different industries have different standards for which holidays are excluded from business day calculations. Here is a practical guide for the most common contexts.

Legal and Court Deadlines

Courts follow their own holiday calendars, which typically include all national, federal or state holidays plus any court-specific closure days. When calculating a legal deadline in business days, always use the court holiday calendar for the relevant jurisdiction. Court-specific closures beyond the standard national holidays can affect a deadline date.

Banking and Financial Transactions

Banks follow the Federal Reserve holiday calendar in the United States. This calendar includes all 11 federal holidays. Wire transfers, ACH payments, and loan processing windows are all calculated based on banking business days. A transfer submitted on the day before a federal holiday will not begin processing until the next banking business day after the holiday.

Payroll Processing

Payroll providers and HR departments calculate pay periods and processing deadlines using business days. When a standard payday falls on a federal holiday, the actual payment date moves to either the preceding or following business day, depending on the employer’s policy. Payroll calculations that span holiday periods require holiday exclusion for accurate processing deadline tracking.

Shipping and Logistics

Major carriers in the United States do not operate delivery services on the 6 primary US federal holidays: New Year’s Day, Memorial Day, Independence Day, Labour Day, Thanksgiving, and Christmas. Delivery window calculations for services that observe these holidays should exclude these dates for accurate arrival date estimates.

Government and Regulatory Filings

Regulatory agencies, tax authorities, and government bodies follow national and sometimes regional holiday calendars. Filing deadlines that fall on a federal holiday are typically extended to the next business day. When calculating compliance deadlines in business days, always verify whether the relevant agency observes specific holidays.

Calculate Business Days Excluding Holidays in Excel

Excel provides built-in functions that support holiday exclusion in business day calculations.

NETWORKDAYS with Holiday Exclusion

The NETWORKDAYS function accepts an optional third argument that lists the holiday dates to exclude. The syntax is NETWORKDAYS of start date, end date, and a holiday range. Enter your holiday dates in a column on your spreadsheet, reference that column as the holidays argument, and the function automatically excludes those dates from the business day count.

For example, to count business days from January 12 to January 30, excluding Martin Luther King Jr. Day on January 19, enter your holiday date in cell A1 and use NETWORKDAYS with your start date, end date, and A1 as the holidays argument. The function returns 14, matching the manual calculation in Example One above.

WORKDAY with Holiday Exclusion

The WORKDAY function also accepts a holidays argument. Enter your start date, the number of business days to add, and a reference to your holiday dates. The function counts forward by the specified number of business days, skipping weekends and the specified holidays.

For a faster and more accessible approach, our free business day calculator supports holiday exclusion without any spreadsheet formula knowledge required.

Frequently Asked Questions

Use our free business day calculator to calculate business days excluding holidays for any date range or deadline instantly.