Working days calculator
Business days between two dates, Monday to Friday
Counts Monday to Friday and skips weekends. Add your own dates to leave out, such as public holidays.
–
- Weekdays in range
- –
- Weekend days skipped
- –
- Left out from your list
- –
- On your list but not used
- –
What counts as a working day here
This calculator counts Monday to Friday. Saturdays and Sundays are never counted. The start date counts if it is a weekday, and so does the end date while Count the end date is ticked. With it ticked, a Friday to the following Monday is 2 working days (the Friday and the Monday); unticked it is 1. Counting both ends is how the NETWORKDAYS function in spreadsheets behaves, so the default should match a spreadsheet check.
Public holidays
No holiday list is built into this page, because holidays differ by country, state, industry and employer, and a wrong list is worse than none. Paste the dates you want left out instead. Accepted forms are 2026-12-25, 25 Dec 2026 and December 25, 2026. All-number dates such as 03/04/2026 are refused on purpose, since that means 3 April in some countries and March 4 in others.
A date on your list lowers the count only if it is a weekday inside the range. Dates that fall on a weekend or outside the range are shown as not used, and a date entered twice is counted once.
Limits
The count assumes a Monday to Friday week. For a different pattern, use the days between dates page, which splits weekdays from weekend days. Contracts and laws sometimes define "business day" in their own way, so check the wording for anything that matters.