What is considered a working day?

A working day (or business day) is any standard workday on which regular commerce and financial institutions operate. In most western nations, this includes Monday through Friday, excluding official public or statutory holidays.

How many working days are there in a standard calendar year?

In a standard non-leap year (365 days) with a standard Monday-Friday schedule, there are typically 260 to 261 weekdays (52 weeks x 5 days = 260 days + 1 remainder day). When factoring in approximately 10 to 11 public holidays, net working days generally range between 249 and 251 days.

How does Excel or Google Sheets calculate working days?

Spreadsheets use the NETWORKDAYS(start_date, end_date, [holidays]) function for standard Saturday/Sunday weekends, or NETWORKDAYS.INTL(start_date, end_date, [weekend_code], [holidays]) for custom weekend arrangements.

How do you calculate a completion date when adding working days?

To add working days, start on the given date and increment day-by-day, skipping any weekend days and designated holidays until the target number of working days has been accumulated.

What is the difference between calendar days and business days?

Calendar days encompass all consecutive 24-hour periods without exception (all 365 or 366 days in a year). Business days only count official workdays, excluding weekends and official statutory holidays.

Working Days Calculator | Free Business Days, Hours & Holiday Calculator

Interactive Diagram 1

Visual Calendar & Day Status Matrix

Hover or click on individual days in your active range to view exact classifications, day-of-week indices, and statutory holiday names.

Working Day Weekend Day Public Holiday Custom Company Off

Displaying: October 1, 2026 – October 31, 2026

Interactive Diagram 2

How the Working Days Engine Computes Time

Follow the exact algorithmic decision tree used by payroll, logistics, and spreadsheet formulas to resolve calendar dates into billable days.

Step 1

Date Span Range

Inputs Start Date and End Date. Evaluates total elapsed calendar days inclusive.

$$D_{\text{total}} = \text{Date}_{\text{end}} - \text{Date}_{\text{start}} + 1$$

Step 2

Filter Weekend Days

Evaluates day-of-week index (0 = Sun, 6 = Sat). Excludes configured rest days.

$$W_{\text{weekdays}} = D_{\text{total}} - N_{\text{weekends}}$$

Step 3

Deduct Public Holidays

Excludes statutory & bank holidays, ignoring holidays that already fall on weekends.

$$H_{\text{deducted}} = H \cap \text{Weekdays}$$

Step 4

Net Working Capacity

Yields final business days, multiplied by working hours/day for exact capacity.

$$\text{Net Hours} = W_{\text{net}} \times h_{\text{daily}}$$

Formulas & Mathematical Logic

The Mathematics of Business Days

Master the exact mathematical formulation, spreadsheet function implementations, and algorithm optimizations used worldwide.

Core Formula

Net Working Days Formula

$$W_{\text{net}} = D_{\text{calendar}} - (W_{\text{sat}} + W_{\text{sun}}) - \sum_{i=1}^{k} \mathbb{I}(H_i \notin \text{Weekend})$$

$D_{\text{calendar}}$ Total calendar days between start and end date inclusive.

$W_{\text{sat}}, W_{\text{sun}}$ Total count of Saturdays and Sundays in the span.

$H_i$ Statutory holidays occurring strictly on Monday through Friday.

Spreadsheets

Excel & Google Sheets Functions

              Standard:
              =NETWORKDAYS(A2, B2, HolidaysRange)
            
              Custom Weekend:
              =NETWORKDAYS.INTL(A2, B2, "0000011", HolidaysRange)
            
              Add Business Days:
              =WORKDAY(A2, 15, HolidaysRange)

The 7-character string "0000011" represents Mon-Sun, where 1 denotes a rest day and 0 is a workday.

Annual Derivation

Annual Weekday Decomposition

$$365 = 52 \times 7 + 1 \implies \text{Weekdays} = 52 \times 5 + R_1$$

In standard years, 52 weeks contain 260 weekdays. The 1 remainder day can fall on a weekday (yielding 261 weekdays) or a weekend (yielding 260 weekdays). In leap years (366 days), 2 remainder days yield either 260, 261, or 262 weekdays!

Financial

Billable Capacity & Payroll

$$\text{Total Billing} = (W_{\text{net}} \times h_{\text{std}} \times R_{\text{base}}) + (h_{\text{ot}} \times R_{\text{base}} \times M_{\text{ot}})$$

$h_{\text{std}}$ Standard shift hours (typically 8.0 or 7.5 hrs).

$R_{\text{base}}$ Standard hourly billing or wage rate.

$M_{\text{ot}}$ Overtime premium rate multiplier (1.5x or 2.0x).

Annual Capacity

2026 Working Days Reference Matrix

Standard quarterly breakdown of calendar days, weekends, federal holidays, and working hours for 2026.

Quarter 1 (Jan – Mar 2026)

90 Days Total

65 Working Days

520 Hours (8h/day)

2 Federal Holidays

January: 21 Working Days

February: 20 Working Days

March: 22 Working Days

Quarter 2 (Apr – Jun 2026)

91 Days Total

64 Working Days

512 Hours (8h/day)

2 Federal Holidays

April: 22 Working Days

May: 21 Working Days

June: 21 Working Days

Quarter 3 (Jul – Sep 2026)

92 Days Total

64 Working Days

512 Hours (8h/day)

2 Federal Holidays

July: 22 Working Days

August: 21 Working Days

September: 21 Working Days

Quarter 4 (Oct – Dec 2026)

92 Days Total

63 Working Days

504 Hours (8h/day)

4 Federal Holidays

October: 22 Working Days

November: 20 Working Days

December: 21 Working Days

Industry Applications

Why Working Days Calculation Matters

Accurate business day mathematics is fundamental across payroll, project management, legal contracts, and supply chain logistics.

HR & Payroll Compliance

Determines paid time off (PTO) accrual, prorated salaries for employees starting mid-month, and legal overtime compensation rules for both exempt and non-exempt workforces.

Software Sprints & Agile Capacity

Agile velocity hinges on exact engineer working days. In a two-week sprint, public holidays directly reduce story point capacity from 10 working days down to 8 or 9 days.

Supply Chain & Lead Times

Logistics freight carriers guarantee transit in business days (e.g., 3-day ground). Weekend transit halts and customs holiday closures determine accurate delivery commitments.

Legal Notice & Financial Settlement

Financial exchanges operate on T+1 or T+2 business day settlement rules. Legal contracts mandate 10 or 30 business days for appeals, rescission, and notice response.

Frequently Asked Questions

Everything You Need to Know About Working Days

Detailed answers on international holiday calendars, 4-day work weeks, leap years, and banking rules.

What exactly is a "working day" or "business day"? ▾

A working day (often called a business day) is any official day of the week on which regular businesses, government agencies, and financial institutions operate. In North America, Europe, and most international markets, a standard working week consists of Monday through Friday (5 days), while Saturday and Sunday are observed as rest days. Any official federal, national, or statutory bank holidays that fall on a weekday are excluded from working day totals.

How many working days are in a standard year (2026)? ▾

In 2026 (a standard non-leap year of 365 days):

There are exactly 52 full weeks plus 1 extra day.
Because January 1, 2026 falls on a Thursday, there are exactly 261 weekdays (Monday through Friday).
In the United States, there are 11 official federal holidays. All 11 fall on weekdays in 2026.
Therefore, net working days for 2026 in the United States equal 261 − 11 = 250 working days.
At standard 8 hours per day, this totals exactly 2,000 working hours.

What happens if a public holiday falls on a weekend? ▾

When an official statutory holiday falls on a Saturday or Sunday, most governments declare an "observed holiday" on the adjacent weekday:

If the holiday falls on Saturday, it is typically observed on the preceding Friday.
If the holiday falls on Sunday, it is typically observed on the following Monday.

Our calculator's built-in holiday rules automatically track observed weekday dates so your working day counts remain strictly accurate.

How do I calculate working days in Microsoft Excel or Google Sheets? ▾

Both Excel and Google Sheets offer powerful built-in functions:

=NETWORKDAYS(start_date, end_date, [holidays]): Calculates working days between two dates, automatically skipping Saturdays, Sundays, and dates listed in your optional holidays range.
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]): Gives full control over weekend days (e.g., 1 for Sat/Sun, 7 for Fri/Sat, or a 7-character string like "0000011").
=WORKDAY(start_date, days, [holidays]): Computes the future or past date when adding or subtracting N business days.

How does a 4-day work week affect working days calculations? ▾

Under a 4-day work week (e.g., Monday through Thursday with Fridays off), employees work 4 days instead of 5 days per week. In a typical year:

Standard 5-day week: ~260 weekdays (~2,080 standard hours).
4-day week (32 hrs/week): ~208 working days (~1,664 hours).
4-day week (10 hrs/day = 40 hrs/week): ~208 working days (2,080 hours).

You can easily model this in our calculator by unchecking "Friday" under the Weekend Schedule settings!

What are the statutory federal holidays in the United States? ▾

The United States federal government recognizes 11 official public holidays:

New Year's Day (January 1)
Martin Luther King Jr. Day (Third Monday in January)
Washington's Birthday / Presidents' Day (Third Monday in February)
Memorial Day (Last Monday in May)
Juneteenth National Independence Day (June 19)
Independence Day (July 4)
Labor Day (First Monday in September)
Columbus Day / Indigenous Peoples' Day (Second Monday in October)
Veterans Day (November 11)
Thanksgiving Day (Fourth Thursday in November)
Christmas Day (December 25)

Working Days Calculator

Working Days Between Dates

Add or Subtract Working Days

Work Hours & Payroll Estimator

Visual Calendar & Day Status Matrix

How the Working Days Engine Computes Time

Date Span Range

Filter Weekend Days

Deduct Public Holidays

Net Working Capacity

The Mathematics of Business Days

Net Working Days Formula

Excel & Google Sheets Functions

Annual Weekday Decomposition

Billable Capacity & Payroll

2026 Working Days Reference Matrix

Quarter 1 (Jan – Mar 2026)

Quarter 2 (Apr – Jun 2026)

Quarter 3 (Jul – Sep 2026)

Quarter 4 (Oct – Dec 2026)

Why Working Days Calculation Matters

HR & Payroll Compliance

Software Sprints & Agile Capacity

Supply Chain & Lead Times

Legal Notice & Financial Settlement

Everything You Need to Know About Working Days