
Business Days Calculator Complete Guide: Exclude Weekends, Federal Holidays, and Banking Settlement Days
Subject matter specialists in payroll regulations, calendar standards, and temporal mathematics. Meet the team • Our editorial process
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](/tools/business-days-calculator) or track upcoming target milestones with our [countdown timer calculator](/tools/countdown-timer-calculator). 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 calculation guide](/blog/hours-to-days-explained). 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.
Table of Contents
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 Workdays Comparison: A standard month of 30 calendar days contains approximately 20 to 22 working days, depending on how weekends fall and whether public holidays occur during that month.

2. Step-by-Step Algorithm: Calculating Business Days Manually
To calculate the exact number of operational workdays 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). To compute total elapsed calendar time between transaction dates, launch our date duration calculator.
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.
Business Days Calculator Tool
Auto-calculate working days between dates excluding holidays.
Try Calculator Tool Now
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. To project future milestone dates directly, use our date add subtract calculator.
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). Try it with your own delivery schedule to calculate business days.
5. Software Implementation: Excel, Google Sheets, & SQL Formulas
Microsoft Excel and Google Sheets provide built-in financial formulas specifically designed to compute working 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 working days to a start date, returning the future target business date.
6. Worked Practical Scenarios: ACH Banking & Freight Shipping
Scenario 1: Real-World HR Payroll Direct Deposit Settlement (Thanksgiving Holiday Week). An HR payroll operations director oversees semi-monthly direct deposits for 350 personnel. Under NACHA operating rules, standard Automated Clearing House (ACH) direct deposit requires a 2-business-day processing cycle between file submission and the target employee pay date of Friday, November 27, 2026 (the day after Thanksgiving):
• Target Pay Date: Friday, November 27, 2026.
• Thursday, November 26, 2026 (Thanksgiving Day): Federal Reserve Bank holiday under 5 U.S.C. § 6103. All 12 regional Federal Reserve Banks are closed; ACH settlement and wire transmissions cease. This weekday does NOT count toward the 2-day requirement.
• Wednesday, November 25, 2026: Working Day 1 (Federal Reserve ACH network processes the clearing batch).
• Tuesday, November 24, 2026: Working Day 2 (Final deadline for HR to submit the NACHA batch file before the 5:00 PM EST banking cutoff).
Operational Risk Audit: If payroll is submitted on Wednesday, November 25, Thursday is skipped due to the statutory federal holiday, providing only 1 working day before Friday. Consequently, funds will not settle until Monday, November 30, triggering state wage compliance violations under California Labor Code § 204. By auditing working days with holiday exclusions, the payroll team successfully avoids late disbursement penalties.
Scenario 2: SEC T+1 Securities Settlement Standard (May 2024 Rule Amendment). When an investor executes a corporate bond or equity trade on a Friday afternoon, SEC Rule 15c6-1 dictates settlement within exactly 1 operational business day (T+1). Saturday and Sunday are excluded from the clearing cycle. Therefore, securities ownership and cash wire transfers settle on Monday morning. If Monday happens to be a statutory holiday (such as Memorial Day or Labor Day), the settlement date automatically moves forward to Tuesday.
Recommended Internal Links & Calculator Suite
Business Days Calculator Tool
Auto-calculate working days between dates excluding holidays.
Milestone Countdown Calculator
Track target milestone dates and remaining business hours.
Working Hours Timesheet Calculator
Calculate daily shift hours and weekly payroll totals.
Hours to Days Conversion Guide
Detailed analysis of converting labor hours into 8-hour workdays versus 24-hour calendar days.
Timesheet Work Hours & Lunch Breaks Guide
In-depth guide to computing daily work shift hours and unpaid break deductions.
Official Standards & External References
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 operational days). • Weekend Days: Saturday and Sunday are classified as non-working days, during which government agencies, civil courts, commercial banking institutions, and clearinghouse networks (such as the Federal Reserve ACH and Fedwire) suspend routine settlement processing. • International Differences: In certain Middle Eastern nations (such as Jordan, Kuwait, and Qatar), the official workweek 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 working days while factoring in custom corporate holiday exclusions: • Basic Workday 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). • Projecting Workdays Forward: To determine the delivery date 10 working 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 Settlement 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 working 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 operational workdays ($4 \times 5 = 20$). • 30-Day Months (Apr, Jun, Sep, Nov): Typically 21 to 22 productive days. • 31-Day Months (Jan, Mar, May, Jul, Aug, Oct, Dec): Typically 21 to 23 operational 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 workdays per year ($249.5 \div 12 \approx 20.8$ working days per month). Human resources and FP&A accounting teams use the standard 21.67 average monthly workday metric to calculate daily payroll burn rates and per-diem billing allocations.
Q5:How long is 10 business days in calendar days and weeks?
10 business days is exactly 2 full calendar weeks (14 total calendar days), provided no public holidays fall within the interval. Because a standard business week consists of 5 workdays (Monday through Friday), 10 business days includes two 5-day work periods separated by two weekends (4 weekend days total): 10 workdays + 4 weekend days = 14 calendar days. If a statutory federal holiday falls on a weekday, 10 business days expands to 15 or 16 calendar days.
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.
Related Guides & Articles

Days to Weeks Calculator Guide: ISO 8601 Standards, Modulo Math, and Project Planning

Date & Calendar Duration Guide: Calculating Exact Elapsed Time for Project Milestones, Contract Deadlines & Statutory Periods (MM/DD/YYYY)
