Business Days Calculator
Count working days between two dates.
How many working days are there between two dates?
Working days are the days between two dates excluding the weekend days you choose and any dates you list as holidays.
Formula: Count Monday through Friday across the selected range, then exclude valid entered holidays.
What this calculator does
Count Monday-to-Friday business days and optionally exclude your own holiday dates. Handles weekends, leap years, and inclusive date ranges.
Use it to turn Start date, End date, Include the end date, Holidays to exclude into a checked result you can compare, copy, or rerun with different assumptions.
The page shows the formula, a numeric worked example, and the assumptions that affect this everyday calculation.
Inputs and what they mean
- Start date
- — date value.
- End date
- — date value.
- Include the end date
- — yes/no value.
- Holidays to exclude
- — Optional dates separated by commas, spaces, or new lines..
How to use it
- Enter the dates, times, or schedule details.
- Adjust the available options for your situation.
- Review and copy the instant result.
Formula
Count Monday through Friday across the selected range, then exclude valid entered holidays.
Inputs used: Start date, End date, Include the end date, Holidays to exclude.
Edge handling: Start date is required.; Start date must use a valid calendar date.; End date is required.; End date must use a valid calendar date..
Worked example
One working week
- Start with Start date: 2026-09-14, End date: 2026-09-18, Include the end date: true, Holidays to exclude: .
- Apply the method: Count Monday through Friday across the selected range, then exclude valid entered holidays.
- Count weekdays from Monday through Friday.
Reading the result
The headline figure is the main answer. Any breakdown underneath shows the parts that make it up, so you can check the working and see what changes when you adjust an input.
Limitations and assumptions
- Inputs outside the supported range are rejected rather than forced into a result.
- The result depends on the values you enter for this business days calculator; it does not supply missing rates, rules, prices, dates, or assumptions for you.
Common questions
How many working days are there between two dates?
Working days are the days between two dates excluding the weekend days you choose and any dates you list as holidays. Check the formula, example, and limitations on this page before using the result for a real everyday decision.
Are public holidays automatic?
No. Holiday calendars differ, so enter the dates you want excluded.
Are weekends excluded?
Yes. Saturday and Sunday are not counted as business days.
How do I use the Business Days Calculator?
Enter the required values for Start date, End date, Include the end date, Holidays to exclude. The calculator applies the formula on this page and shows the main result with any supporting breakdown so you can check the arithmetic.
What formula does the Business Days Calculator use?
Count Monday through Friday across the selected range, then exclude valid entered holidays. The visible formula section above lists the calculation path and the edge cases the page handles, so the result can be checked without relying on the form alone.
Can the Business Days Calculator be used for exact decisions?
Use it as a calculation aid, not as a substitute for checking the underlying rule, contract, policy, or professional advice that applies to your situation. When a result depends on local rules, personal details, prices, or dates, enter those values yourself and confirm them before acting.
Cite this page
Free Calculator. (n.d.). Business Days Calculator. https://freecalculator.tech/tools/business-days-calculator
"Business Days Calculator." Free Calculator, https://freecalculator.tech/tools/business-days-calculator.
Business Days Calculator — Free Calculator, https://freecalculator.tech/tools/business-days-calculator
Related tools
Calculate elapsed hours and minutes between two times, including overnight.