When to use this calculator
Count weekdays while excluding a holiday-date list supplied by you. No national holiday calendar is fetched. You supply all dates to exclude; repeated dates and weekend holidays are not double-counted.
Explore the business days & weekends calculators for other questions in this topic. For a related calculation, use the Weekend Days Between Dates Calculator: Count Saturdays and Sundays in a start-inclusive, end-exclusive calendar interval.
PUTTING IT INTO PRACTICE
Business Days Excluding Holidays: a worked example
The values below are an illustrative example, not a recommendation. Replace them with measurements or assumptions that match your question.
| Input | Example value |
|---|---|
| Start date included | 2026-10-12 |
| End date excluded | 2026-10-19 |
| Holiday dates separated by commas, or none | 2026-10-14 |
| Result | 4 business days |
- Check the input labels and enter the example values above.
- Apply the relationship: Weekdays minus unique listed holidays that fall on weekdays inside the interval..
- The result is 4 business days, rounded for display.
How to interpret your result
No national holiday calendar is fetched. You supply all dates to exclude; repeated dates and weekend holidays are not double-counted.
The default workweek is Monday to Friday. Date ranges use the inclusive and exclusive boundaries stated on each tool. No country holiday list is inferred, and special working Saturdays or weekends require a different calendar model.
Frequently asked questions
Are public holidays excluded automatically?
Only when you enter them in the holiday-list tool. Ordinary business-day tools here exclude Saturdays and Sundays but not public holidays.
When is the business days excluding holidays calculator useful?
Count weekdays while excluding a holiday-date list supplied by you. No national holiday calendar is fetched. You supply all dates to exclude; repeated dates and weekend holidays are not double-counted.
How do I use the business days excluding holidays calculator?
Enter start date included, end date excluded, holiday dates separated by commas, or none. The result updates automatically. Use the units shown beside each input; the example values illustrate the method.
Which formula does this calculator use?
Weekdays minus unique listed holidays that fall on weekdays inside the interval..
What should I check before using the result?
No national holiday calendar is fetched. You supply all dates to exclude; repeated dates and weekend holidays are not double-counted.
How are results rounded?
Scalar numbers display up to six decimal places, with scientific notation for very large or small values. Text, fraction, date and schedule outputs use the format described on the tool. Intermediate calculations use JavaScript floating-point arithmetic. Keep sensible precision for your measurements.
Further reading
For background on this topic, see MDN: date values and calendar handling ↗. This is a topic reference, not an external review or endorsement of this tool.
Calculators Map editorial process · Updated · Methods and limitations