Are weekends excluded?
Yes. Saturday and Sunday are not counted.
Business Days Calculator
Count Monday–Friday working days between two dates for deadlines, delivery estimates, and SLA windows.
Count business days
Enter start and end dates, then choose whether the end date is included in the count.
About this calculator
How to use Business Days Calculator, plus the formulas and logic behind the results.
Tool description
The Business Days Calculator counts weekdays between two dates. It supports inclusive or exclusive end dates so you can match common deadline and SLA conventions.
How to use
- Enter the start date and end date.
- Choose whether to include the end date.
- Select Calculate to see the working-day total.
Formulas & reference
for each date d from start..end: count if weekday (Mon–Fri)if include_end = no: iterate only through end − 1 day
Counting rules
- Saturday and Sunday are excluded
- Public holidays are not excluded by default
- Order of dates is normalized if end is before start
Calculation logic
Dates are walked day by day. Each date with ISO weekday 1–5 increments the counter. If end is before start, the range is swapped so the count stays non-negative.
This calculator excludes weekends only. Company or regional public holidays are not subtracted automatically.
Business Days Calculator FAQ
Common questions about this calculator and how to use the results.
Are holidays excluded?
Not automatically. Adjust manually if your region has public holidays.
What does include end date mean?
Yes counts both endpoints when they are weekdays. No stops before the end date.
What if start and end are the same weekday?
With include end = Yes, the count is 1. With No, the count is 0.
Does order of dates matter?
If end is earlier, the tool swaps the range and still returns a positive weekday count.
Is this the same as network days in Excel?
Similar to NETWORKDAYS without a holiday list.
Can I count only business hours?
This tool counts whole business days, not hours within a day.
Which days are business days?
Monday through Friday.