Business Days Calculator
Count business days between two dates or add and subtract business days with weekends and optional U.S. federal holidays excluded.
Count business days between dates
English SERPs for business days focus on workday counting, project deadlines and Excel-style NETWORKDAYS logic. This page counts weekdays between two dates and can exclude common observed U.S. federal holidays.
- Dbusiness — business days counted in the selected range.
- d — each calendar date from start through end.
- start — the first date in the range.
- end — the last date in the range.
- I — the include/exclude test for weekends and selected holidays.
Add or subtract workdays
In add/subtract mode, the start date is the anchor. A one-business-day offset moves to the next eligible business day rather than counting the anchor itself.
- dateResult — the returned calendar date.
- start — the anchor date.
- Nbusiness — the number of business days to move.
- plusMinus — forward for positive values and backward for negative values.
Frequently Asked Questions
Sources and References
- NETWORKDAYS functionMicrosoft Support
- Federal holidaysU.S. Office of Personnel Management
- Business Day CalculatorInch Calculator
- Working Days CalculatorWorking Days Calculator
Calculations are based on the listed reference sources. Links open in a new tab.
Related Tools
Calculate the date difference between two dates or add and subtract calendar days from a start date, with full calendar breakdowns.
Calculate the number of days between two dates, with exclusive or inclusive counting, weeks, calendar years/months/days and weekday/weekend totals.
Add or subtract calendar days from a start date, then see the resulting date, weekday, ISO week, day of year and month calendar.
Find the weekday for any date, including birth dates and future dates, with ISO day number, ISO week-year, day of year, weekend status and leap-year context.
Show every ISO week in a selected year with Monday-Sunday date ranges, quarter labels, current-week highlighting and table copy.
Count how many calendar days are left until an event or how many days have passed since it, with weeks, months, weekday and rough weekday totals.