Corporate banking skyscraper representing financial institutions observing business day settlement schedules

Guides

Business Days Calculator Complete Guide: Exclude Weekends, Federal Holidays, and Banking Settlement Days

Emily Rose, HR Operations Specialist & Corporate Governance Analyst August 17, 2026 15 min read

In global commerce, banking ACH settlements, international freight logistics, legal contract execution, and corporate project management, deadlines are almost universally stated in "business days" or "working days" rather than standard calendar days. You can compute working days between dates instantly using our [Business Days Calculator Tool](#tab:business-days) or track upcoming target milestones with our [Milestone Countdown Calculator](#tab:countdown). For instance, an agreement specifying "5 business days" explicitly excludes weekend days (Saturday and Sunday) and public holidays. To see how labor hours map into workdays, consult our [Hours to Days Conversion Guide](#article:hours-to-days-conversion-work-vs-calendar-days). In this comprehensive master guide, we break down how business day calculations work, step-by-step algorithms, international weekend variations, Federal Reserve banking schedules, and spreadsheet formulas.

Key Takeaways & Expert Insights

Define the standard Western business week (Monday through Friday, 5 operational days).
Exclude non-working weekend days (Saturdays and Sundays) accurately.
Deduct official government and Federal Reserve banking public holidays.
Understand regional weekend variations (e.g. Sunday-Thursday in Israel, UAE Friday-Saturday shifts).
Implement business day formulas in Excel (`NETWORKDAYS`, `WORKDAY`) and SQL database queries.

1. What is a Business Day? Operational vs Calendar Days

A business day (also referred to as a workday) is defined as any official working day of the week on which commercial financial institutions, government agencies, and corporate offices operate.

In the Western world (North America, South America, Europe, Australia, and most of Asia), the standard workweek runs from Monday through Friday. Saturdays and Sundays are classified as non-working weekend days.

Calendar Days vs Business Days Comparison: A standard month of 30 calendar days contains approximately 20 to 22 business days, depending on how weekends fall and whether public holidays occur during that month.

Business professional checking corporate holiday schedule on smartphone — Figure 1: Business day calculations standardly strip out Saturdays and Sundays.

2. Step-by-Step Algorithm: Calculating Business Days Manually

To calculate the exact number of business days between a Start Date and an End Date manually, follow this 5-step algorithm:

Step 1: Determine Total Calendar Days: Subtract Start Date from End Date (Total Calendar Days = End Date - Start Date).

Step 2: Count Full Weeks: Divide Total Calendar Days by 7 to find full 7-day calendar weeks.

Step 3: Deduct Weekend Days: Multiply the number of full weeks by 2 (since each 7-day week contains 1 Saturday and 1 Sunday). Subtract leftover weekend days from partial weeks.

Step 4: Identify & Deduct Weekday Public Holidays: List all official national, state, or corporate holidays falling within the range. Exclude any holiday that falls on a Saturday or Sunday (since it was already deducted in Step 3), and deduct only holidays falling on Monday through Friday.

Step 5: Compute Final Net Business Days: Net Business Days = Total Calendar Days - Weekend Days - Weekday Holidays.

Interactive Site Tool & Resource

Business Days Calculator Tool

Auto-calculate working days between dates excluding holidays.

Try Calculator Tool Now

Banking ACH wire settlement documentation detailing 2 business day clearing schedule — Figure 2: Public holidays falling on weekdays must also be deducted from active working days.

Net_Business_Days = Total_Calendar_Days - Weekend_Days - Weekday_Public_Holidays

3. Accounting for Federal Public Holidays & Banking Schedules

In the United States, the Federal Reserve Bank observes 11 official federal holidays each year. On these days, wire transfers (Fedwire), ACH direct deposit clearing, and check processing cease:

1. New Year’s Day (Jan 1)

2. Martin Luther King Jr. Day (3rd Mon in Jan)

3. Washington’s Birthday / Presidents’ Day (3rd Mon in Feb)

4. Memorial Day (Last Mon in May)

5. Juneteenth National Independence Day (June 19)

6. Independence Day (July 4)

7. Labor Day (1st Mon in Sept)

8. Columbus Day / Indigenous Peoples’ Day (2nd Mon in Oct)

9. Veterans Day (Nov 11)

10. Thanksgiving Day (4th Thurs in Nov)

11. Christmas Day (Dec 25)

Federal Holiday Observed Rules: If a fixed-date holiday (e.g. July 4 or Dec 25) falls on a Sunday, the following Monday is designated as the official observed holiday. If it falls on a Saturday, the preceding Friday is designated as the observed holiday.

4. International Regional Workweek & Weekend Variations

Business day calculations must account for regional cultural and legal workweek definitions when conducting international business:

• Western Standard (Mon–Fri): Americas, Europe, Australia, East Asia. Weekend: Sat–Sun.

• Middle East Sunday–Thursday (Sun–Thu): Israel, Jordan, Kuwait, Qatar. Weekend: Fri–Sat.

• United Arab Emirates (Mon–Fri 4.5 Days): In 2022, the UAE transitioned to a Monday–Friday 4.5-day workweek (Monday to Friday noon).

5. Software Implementation: Excel, Google Sheets, & SQL Formulas

Microsoft Excel and Google Sheets provide built-in financial formulas specifically designed to compute business days:

• `NETWORKDAYS(start_date, end_date, [holidays])`: Calculates net working days between two dates, automatically excluding weekends and custom holiday ranges.

• `NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])`: Allows specifying custom weekend patterns (e.g., specifying Sunday and Monday as weekends).

• `WORKDAY(start_date, days, [holidays])`: Adds N business days to a start date, returning the future target business date.

6. Worked Practical Scenarios: ACH Banking & Freight Shipping

Scenario 1: ACH Bank Direct Deposit Settlement. A company initiates payroll direct deposit on Wednesday afternoon with a "2 business day settlement" requirement. Day 1: Thursday (Business Day 1). Day 2: Friday (Business Day 2). Funds settle into employee accounts on Friday morning.

Scenario 2: Overseas Container Freight Shipping. An ocean container departs Shanghai on Friday, July 10, with an estimated transit time of 10 business days. Saturday July 11 and Sunday July 12 are skipped. Week 1 business days: Mon July 13 to Fri July 17 (5 business days). Week 2 business days: Mon July 20 to Fri July 24 (5 business days). Arrival date = Friday, July 24 (14 calendar days elapsed).

Official Standards & External References

FederalReserve.gov

Federal Reserve Bank Payment Settlement Holiday Schedule

Official banking holiday schedule governing wire settlements and clearing.

OPM.gov

US Federal Government (OPM) Official Public Holidays Schedule

Official federal employee holiday schedule.

Frequently Asked Questions

Q1:Do business days include weekends?

No. In standard commercial, legal, and financial operations across the United States, Canada, the United Kingdom, and Australia, business days (also known as working days) explicitly exclude Saturdays and Sundays: • The Standard Western Business Week: Runs from Monday morning through Friday evening (5 consecutive working days). • Weekend Days: Saturday and Sunday are classified as non-business days, during which government offices, civil courts, federal regulatory agencies, commercial banks, and clearinghouse networks (such as the Federal Reserve ACH and Fedwire) are closed for general transaction processing. • International Differences: In certain Middle Eastern nations (such as Jordan, Kuwait, and Qatar), the official working week runs from Sunday through Thursday, with Friday and Saturday serving as the weekend. When a commercial agreement or shipping contract specifies "delivery within 3 business days" starting on a Thursday, the timeline spans Friday (Day 1), skips Saturday and Sunday, spans Monday (Day 2), and culminates on Tuesday (Day 3)—spanning 5 full calendar days.

Q2:How do I calculate business days in Excel between two dates?

Microsoft Excel and Google Sheets provide dedicated temporal functions designed to compute net business days while factoring in custom corporate holiday exclusions: • Basic Business Days Formula: `=NETWORKDAYS(A2, B2)` (Where cell A2 contains Start Date and B2 contains End Date. Automatically excludes all Saturdays and Sundays). • Factoring in Public Holidays: `=NETWORKDAYS(A2, B2, C2:C10)` (Where range C2:C10 contains a list of official bank holiday dates to deduct from the working count). • Custom Weekend Patterns (International): `=NETWORKDAYS.INTL(A2, B2, 1, C2:C10)` (The third argument allows specifying weekend patterns: `1` = Sat/Sun, `2` = Sun/Mon, `7` = Fri/Sat, or `11` = Sunday only). • Adding Business Days Forward: To determine the delivery date 10 business days after a start date in A2, use `=WORKDAY(A2, 10, C2:C10)`. These functions are standard for supply chain logistics forecasting, SLA tracking, and financial loan origination schedules.

Q3:What happens if a bank holiday falls on a weekend?

Under US federal law (5 U.S.C. § 6103) and state banking regulations, when a statutory public holiday with a fixed calendar date falls on a weekend, it is assigned an "observed holiday" date on the nearest weekday: • Sunday Holidays: If a federal holiday falls on a Sunday (e.g., Christmas Day on Sunday, December 25th), it is officially observed by federal institutions, banks, and courts on the immediately following Monday (Monday, December 26th). • Saturday Holidays: If a federal holiday falls on a Saturday (e.g., Independence Day on Saturday, July 4th), it is observed on the preceding Friday (Friday, July 3rd). • Impact on Business Day Math: On the observed Friday or Monday, commercial banks, postal delivery services, and ACH payment clearinghouses close. Therefore, that observed weekday must be treated as a non-business day in your duration calculations, extending contract notice deadlines by 24 hours.

Q4:How many business days are in a typical month?

A standard calendar month contains between 20 and 23 business days, depending on month length (28, 29, 30, or 31 days), day-of-week calendar alignment, and scheduled statutory holidays: • 28-Day Month (February common): Exactly 20 business days ($4 \times 5 = 20$). • 30-Day Months (Apr, Jun, Sep, Nov): Typically 21 to 22 business days. • 31-Day Months (Jan, Mar, May, Jul, Aug, Oct, Dec): Typically 21 to 23 business days. • Annual Total: A standard year has 260 to 261 total weekdays (52 weeks $\times$ 5 days $= 260$ days). Deducting the 11 US federal bank holidays leaves approximately 249 to 250 net productive business days per year ($249.5 \div 12 \approx 20.8$ business days per month). Human resources and FP&A accounting teams use the standard 21.67 average monthly business day metric to calculate daily payroll burn rates and per-diem billing allocations.

Conclusion & Summary

Calculating business days accurately requires stripping out Saturdays and Sundays, accounting for regional weekend variations, and deducting public banking holidays. Using tools like our Business Days Calculator or Excel `NETWORKDAYS` functions ensures complete precision in legal, banking, and logistics scheduling.