Business Days Calculator
About Business Days Calculator
The business days calculator counts Monday through Friday dates in an inclusive date range and subtracts holidays you enter.
How to Use
The business days calculator counts Monday through Friday dates in an inclusive date range and subtracts holidays you enter. Enter the Start date, End date, and Holidays values and review the Business days, Weekend days, Calendar days, and Holiday assumption outputs after you calculate.
- Open the calculator : Use Business Days Calculator from the Time category.
- Check the inputs : Review the required values and any optional settings.
- Read the formula : Use the formula and notes below to understand how the result is produced.
Common Questions
What does the Business Days Calculator estimate?
Count weekdays between two dates with optional holidays.
What time settings can change the result?
Date boundaries, local time, daylight-saving changes, and timezone settings can affect the result.
Do business days include weekends and holidays?
Standard business days strictly refer to Monday through Friday, excluding weekends. When calculating business days for legal or shipping purposes, you must also manually exclude federal, banking, or regional public holidays, as they are not considered standard working days.
Inputs
- Start date
- End date
- Holidays
Outputs
- Business days
- Weekend days
- Calendar days
- Holiday assumption
Formula
Business days = weekdays in the inclusive date range - holidays.