About the Business Days Calculator
This business days calculator counts the working days in a date range by walking through every day individually and testing which ones fall at the weekend, so leap years and month lengths take care of themselves. By default Monday to Friday count and Saturday and Sunday do not, but each weekend day has its own checkbox for six-day working weeks. A further checkbox controls whether the end date itself is included, since that single decision changes the answer by one and is the most common cause of a disputed count. Public holidays are not deducted.
How to use the Business Days Calculator
- 1
Enter the Start date and the End date; either order is accepted.
- 2
Tick Count Saturday as a working day or Count Sunday as a working day if your week runs longer than five days.
- 3
Decide whether to leave Include the end date in the count ticked, which changes the total by one.
- 4
Read the Working days panel for business days, weekend days, total days and the equivalent in business weeks.
What people use it for
Quoting a delivery or turnaround time
A five-working-day promise made on a Thursday lands the following Thursday, not on the Tuesday a simple day count would suggest.
Calculating notice periods
Employment and tenancy notice is frequently specified in working days, so the count needs to skip weekends to establish the correct final date.
Planning project effort
The business weeks figure converts a calendar range directly into the resourcing unit most plans are built in, without you dividing by five yourself.
Retail and hospitality scheduling
Ticking Saturday as a working day matches a six-day retail rota, which makes the count reflect the actual staffed days rather than an office week.
Why public holidays cannot be built in
There is no such thing as a universal holiday calendar. The United States has federal holidays that individual states extend or ignore, the United Kingdom has different bank holidays in England and Wales, Scotland and Northern Ireland, and India has a national list plus a substantial set of state holidays that vary widely. On top of national variation, individual employers set their own closure days and many operate a restricted-holiday system where employees choose a subset from a list. Several major holidays are not on fixed dates at all: Easter moves according to a lunar rule, Eid depends on lunar observation and can differ by a day between countries, and several Asian holidays follow lunisolar calendars. Any built-in list would therefore be wrong for most users most of the time. The practical approach is to take the business day count from this tool and subtract the holidays that actually apply to your organisation and location.
Whether to include the end date
The inclusive checkbox is the single decision that most often makes two people disagree about the same range. Include the end date when you are measuring a period that is worked or served through, such as a contractor's engagement, a leave request or a service window — someone on leave from Monday to Friday takes five days, not four. Leave it off when you are measuring the gap between two events, such as the days between an order being placed and it arriving. Contracts and regulations usually specify which convention applies, often with wording like within five business days of receipt, where the day of receipt itself is typically excluded and the count begins the following working day. When it genuinely matters, agree the convention in writing rather than assuming, since a one-day discrepancy on a deadline is exactly the sort of thing that reaches a dispute.
Tips
- Subtract your own public holidays from the business days figure — they are deliberately not deducted here.
- The business weeks reading is business days divided by five, so it stays meaningful even with a six-day week ticked.
- For a working-day deadline in the future, use the add or subtract days tool and then check the result is not a weekend.