The Working Days Formula: How It Works
Whether you are planning project delivery milestones, forecasting invoicing cycles, or scheduling annual leave, calculating calendar days instead of actual working days is one of the easiest ways to throw a deadline off track. A 14-day turnaround sounds generous until you realize it spans two full weekends and a bank holiday, leaving your team with only nine productive workdays.
Calculating business days accurately requires accounting for two distinct variables: weekly rest days and jurisdiction-specific statutory holidays. Here is how to calculate working days manually, in spreadsheets, or automatically across international borders.
Notice the + 1 in the calendar day calculation: standard date subtraction is exclusive of the start date. If a task begins on Monday morning and ends on Wednesday evening, simple math (3 − 1 = 2) undercounts the duration. Adding 1 ensures both boundary days are counted.
Example Calculation
Suppose you have a project running from Monday, May 18, 2026, to Friday, May 29, 2026, in the United States:
- Total calendar days: 12 days (May 18 through May 29 inclusive).
- Weekend days: 2 days (Saturday, May 23 and Sunday, May 24).
- Public holidays: 1 day (Memorial Day on Monday, May 25).
- Net working days: 12 − 2 − 1 = 9 working days.
For instant multi-country calculations that adjust for local calendars without manual tracking, you can run the dates through the HolidayExplore Working Days Calculator.
Business Days vs. Working Days: What Is the Difference?
While people frequently treat "working days" and "business days" as synonyms, contractual and legal contexts draw important distinctions between them:
| Dimension | Business Days | Working Days |
|---|---|---|
| Standard Definition | Official days of commercial and banking operations (usually Monday through Friday). | Days an employee or contractor is contractually expected to perform work. |
| Bank & Clearing Halts | Always excluded when central clearing rails (Fedwire, CHAPS, SEPA) close. | May still be working days for shift workers, retail, logistics, or hospitality. |
| Weekends | Strictly excludes Saturdays and Sundays. | Can include Saturdays or Sundays depending on local labor laws or shift schedules. |
| Primary Use Case | Contract cure periods, loan closings, direct deposit timing, legal notices. | Sprint planning, timesheets, manufacturing cycles, individual PTO deductions. |
Do Public Holidays Count as Working Days?
In commercial office environments and legal contracts, public and statutory holidays do not count as working days. However, public holidays only reduce the working day count if they fall on an otherwise regular workday.
A common mistake in manual calculation is subtracting every public holiday on the calendar without checking the day of the week. If an official holiday falls on a Saturday, it has already been removed by your weekend deduction. Deducting it a second time skews your total.
The exception occurs in jurisdictions that enforce statutory rollover rules (often called "Mondayisation"). In countries like the United Kingdom and the United States, weekend holidays transfer to the nearest Monday or Friday:
- In the United States (5 U.S.C. § 6103), a federal holiday that falls on a Sunday is officially observed on Monday; a Saturday holiday is observed on Friday.
- In the United Kingdom (Banking and Financial Dealings Act 1971), weekend bank holidays trigger an official substitute bank holiday on the following Monday.
- In countries like Germany or France, weekend holidays typically expire without an in-lieu weekday off, meaning workers lose the weekday rest.
If you manage distributed contractors across different time zones, you can pair your schedule with the Holiday Overlap Finder to spot days where one office is offline while another is operating.
How Many Working Days Are in 2026?
The year 2026 is a standard common year of 365 calendar days. It begins on a Thursday (January 1) and ends on a Thursday (December 31).
Across 52 weeks and 1 day, the year 2026 contains exactly:
- 365 total calendar days
- 104 weekend days (52 Saturdays and 52 Sundays)
- 261 total weekdays (Monday through Friday)
To find the true working day baseline for 2026, deduct the weekday public holidays recognized in your specific country:
| Country | Total Weekdays | Observed Weekday Holidays | Net Working Days in 2026 |
|---|---|---|---|
| United States (Federal) | 261 | 11 | 250 |
| United Kingdom (England & Wales) | 261 | 8 | 253 |
| Canada (Federal) | 261 | 10 | 251 |
| Australia (National Baseline) | 261 | 10 | 251 |
If you are calculating personal leave to stretch these workdays into extended breaks, run your remaining days through the 2026 PTO Maximizer to locate optimal bridge days.
How to Calculate Business Days in Excel & Google Sheets
If you maintain your milestones or employee schedules in a spreadsheet, do not subtract dates manually. Both Microsoft Excel and Google Sheets feature built-in formulas designed specifically for working-day math.
1. The Standard NETWORKDAYS Formula
The cleanest formula for a conventional Monday-through-Friday schedule is NETWORKDAYS:
The third parameter, [holidays], is optional but essential for precision. You can select a range of cells (such as H2:H12) containing your country's observed bank holiday dates. Excel will automatically exclude weekends and any holiday falling between the start and end dates.
2. The NETWORKDAYS.INTL Formula (Custom Work Weeks)
If your team operates on a 6-day schedule, works over weekends, or is based in regions with a Sunday-to-Thursday business week (common in parts of the Middle East), use NETWORKDAYS.INTL:
By replacing weekend_code with numbers like 1 (Saturday/Sunday), 7 (Friday/Saturday), or 11 (Sunday only), you can align calculations to any international operational model.
Sources & Methodology
Statutory calendar rules and banking cut-offs are verified against Title 5 of the United States Code (5 U.S.C. § 6103), the UK Banking and Financial Dealings Act 1971, the Canada Labour Code, and Australia's Fair Work Act 2009. Spreadsheet formulas adhere to Microsoft Office and Google Sheets documentation.
Written by Sahin Choudhury
Founder and lead researcher at HolidayExplore. Researching public calendars, banking clearing schedules, and workplace award regulations.