Work Days Between Dates Calculator

Count the working days (Monday to Friday) between two dates, excluding any holidays.

Result

Business days
21
Weekdays (Mon–Fri)
21
Weekend days
10
Total days
31
Export:
Weekdays vs. weekend days
  • Weekdays2167.7%
  • Weekend days1032.3%

How business days are counted

The calculator steps through every date from the start to the end (both included), checking the day of the week for each. Monday through Friday are tallied as weekdays and Saturday and Sunday as weekend days. Business days are the weekday count minus any holidays you enter.

Counting day by day rather than dividing by seven means the result is exact regardless of which weekday the range begins or ends on, including partial weeks at either end.

Reading the breakdown

The pie chart shows how the total range splits between weekdays and weekend days, giving a quick sense of how much usable working time a period contains. The business-days figure goes one step further by removing holidays, which is the number most relevant for project timelines, delivery estimates and leave planning.

Total days is the raw inclusive span for reference, so you can see at a glance how much of the calendar is weekend or holiday rather than working time.

Holidays and limitations

Holiday handling is deliberately simple so it works anywhere:

  • Enter the count of public or company holidays that fall on weekdays within the range; the tool subtracts them from the weekday total.
  • It does not know any holiday calendar, so a holiday landing on a weekend should not be counted (it was never a working day to begin with).
  • The standard Monday–Friday work week is assumed; it cannot model six-day weeks or other custom schedules.
  • Both endpoints are included, so a range from Monday to the next Monday spans two of that weekday.

Formula

businessDays = (weekdays in range) − holidays

Frequently asked questions

Are the start and end dates counted?
Yes. Both the start and end dates are included in the range that is scanned.