5 Ways to Calculate Business Days in Excel & Python (With Free Templates)

Accurately computing working days between arbitrary calendar dates is an essential requirement across corporate finance, payroll engines, supply chain modeling, and project management. Whether you're configuring a simple Google Sheet or engineering a high-throughput Python ETL pipeline, here is the comprehensive guide to programmatic business day arithmetic.

---

1. Microsoft Excel & Google Sheets: NETWORKDAYS vs NETWORKDAYS.INTL

The standard NETWORKDAYS function calculates net working days between two dates, automatically excluding Saturdays and Sundays.

=NETWORKDAYS(A2, B2, HolidayList)

Custom Weekends with NETWORKDAYS.INTL

For Middle Eastern operations (e.g. UAE pre-2022, Saudi Arabia) or custom 4-day shifts, use NETWORKDAYS.INTL:

=NETWORKDAYS.INTL(startDate, endDate, 7, HolidayRange)

Where 7 specifies Friday & Saturday as the weekend.

---

2. Python numpy Vectorized Computation (busday_count)

For massive data frames (millions of rows), numpy.busday_count is orders of magnitude faster than iterative loops:

import numpy as np

# Vectorized working days calculation
start_dates = np.array(['2026-01-01', '2026-03-01'], dtype='datetime64[D]')
end_dates   = np.array(['2026-01-31', '2026-03-31'], dtype='datetime64[D]')
holidays    = ['2026-01-01', '2026-01-19']

working_days = np.busday_count(start_dates, end_dates, holidays=holidays)
print(f"Computed working days: {working_days}")

---

3. Python pandas.bdate_range & Custom Business Day Offsets

When building time-series indices with custom bank holidays:

import pandas as pd
from pandas.tseries.holiday import USFederalHolidayCalendar
from pandas.tseries.offsets import CustomBusinessDay

us_bday = CustomBusinessDay(calendar=USFederalHolidayCalendar())
days = len(pd.bdate_range('2026-01-01', '2026-12-31', freq=us_bday))
print(f"Total US Federal Working Days in 2026: {days}")

---

Summary Best Practices

• Always declare explicit holiday vectors: Implicit holiday assumptions lead to SLA miscalculations.
• Normalize inclusive boundaries: Decide whether Day 0 and Target Day are both counted.
• Use Our Interactive Engine: Use WorkingDaysCalculator.net to cross-verify your formulas with instant multi-country statutory observance rules.