Business Days Between Dates Calculator

A business days calculator tells you the exact number of working days between two dates, excluding weekends (Saturday and Sunday) and optionally any holidays you specify. You enter a start date, an end date, and a list of holidays (if any), and it returns the count of business days, plus often the total calendar days and the end date after adding a given number of working days.

Formula

The core formula counts total days, subtracts weekends, then subtracts holidays. In plain terms:

Business days = Total calendar days − Weekend days − Holidays

Where:

• Total calendar days = (End date − Start date) + 1, counting both endpoints.
• Weekend days = the number of Saturdays and Sundays in that range.
• Holidays = the count of dates you supplied that fall on a weekday (if a holiday lands on a weekend, it is already excluded).

To compute weekend days without a loop, you can use a formula based on the day-of-week of the start date. For example, if the start date is a Monday (day 1) and the total days is N, the number of full weeks is floor(N/7), and the remainder tells you how many extra weekend days to add. Most programming languages have a built-in function for this, but the manual approach works too.

Worked Example

Using the calculator defaults: start date 2025-01-06 (a Monday), end date 2025-01-17 (a Friday), and two holidays on 2025-01-09 and 2025-01-10.

1. Total calendar days = 17 − 6 + 1 = 12 days.
2. Weekend days: the range includes two Saturdays (Jan 11, Jan 18? No, Jan 18 is outside) – actually Jan 11 is Saturday, Jan 12 is Sunday, and Jan 18 is Saturday but that is beyond the end. So exactly 2 weekend days (Jan 11 and 12).
3. Holidays: both Jan 9 and Jan 10 are weekdays (Thursday and Friday), so they both count as holidays.
4. Business days = 12 − 2 − 2 = 8.

So the answer is 8 business days. The calculator’s formula gives the same result.

When to Use a Business Days Calculator

This tool is useful in many real-world situations where “days� mean working days, not calendar days:

• Contract deadlines – “delivery within 10 business daysâ€� is common in procurement and service agreements.
• Legal filings – court rules often count business days for responses and appeals.
• HR and payroll – calculating notice periods, leave balances, or accrual periods.
• Project planning – estimating how long a task will take excluding weekends.
• Shipping and delivery – many carriers promise delivery in business days, not calendar days.

In each case, the calculator removes the mental load of counting weekends manually, especially for long ranges.

How to Choose a Good Business Days Calculator

Not all calculators are equal. Look for these features:

• Ability to add holidays – a fixed holiday list is useless if your company observes different days.
• Option to exclude weekends – some regions have a Friday-Saturday weekend (e.g., in parts of the Middle East), but most tools default to Saturday-Sunday.
• Date range flexibility – you should be able to enter any start and end date, not just presets.
• Clear output – the result should show both business days and calendar days, so you can verify the math.
• No hidden fees or sign-ups – a simple free tool should not require registration.

If you need to count business days from a start date forward (e.g., “what is 15 business days from today?�), make sure the calculator supports that mode as well, because some only do date-to-date counting.

Common Mistakes and Pitfalls

People often trip on these issues:

• Including the start date – some tools count the start date as day 0, others as day 1. Always check the tool’s convention. The formula above counts both endpoints.
• Double-counting holidays – if a holiday falls on a weekend, it should not be subtracted again. A good calculator handles this automatically.
• Timezone differences – if you are in different time zones, the date can shift. Stick to calendar dates, not timestamps.
• Leap years – February 29 adds a day, but the formula handles it because it works on actual dates.
• Regional weekends – in some countries the weekend is Friday-Saturday or Sunday only. If you need that, find a tool that lets you customize the weekend days.

Another common misconception: “business days� always means Monday to Friday. That is true in most Western countries, but not universal. For global teams, clarify the definition first.

Limitations of the Formula

The simple formula assumes a fixed weekend (Saturday-Sunday) and that you manually provide holidays. It does not account for:

• Half-days – some workplaces close early on certain days, but that is not a full business day.
• Unexpected closures – weather, strikes, or emergencies are not predictable.
• Working on weekends – if you work Saturdays, the formula will undercount your actual working days.
• Country-specific holiday calendars – you must enter the holidays yourself; the calculator cannot know them all.

For most practical purposes, the formula is accurate enough. But always verify with a quick manual check for short ranges.

Alternatives to a Business Days Calculator

If you don’t have a calculator handy, you can:

• Count manually – mark off weekends on a calendar and subtract holidays. Works fine for short ranges.
• Use spreadsheet software – Excel’s NETWORKDAYS function does exactly this, and you can pass a range of holiday dates.
• Use a programming language – Python’s numpy.busday_count or JavaScript’s date libraries can do it with a few lines of code.
• Use a date difference website – many general date calculators include a business-day option.

The advantage of a dedicated calculator like this one is speed and simplicity – no need to open a spreadsheet or write code.

Frequently Asked Questions

Does the calculator count the start date as a business day?

Yes, in the formula above, the start date is included. If you want to exclude it, subtract one from the result. Always check the tool’s documentation, as some calculators use a different convention.

What happens if a holiday falls on a weekend?

It is not subtracted twice. The formula first subtracts all weekend days, then subtracts only holidays that fall on weekdays. So a holiday on Saturday is already excluded by the weekend subtraction.

Can I use this for a Friday-Saturday weekend?

Not directly with the default formula, because it assumes Saturday-Sunday. You would need a calculator that lets you customize the weekend days, or you can adjust manually by shifting dates.

How do I add a list of holidays?

Enter the dates in a comma-separated format, e.g., 2025-12-25, 2025-12-26. Make sure the format matches the calculator’s expected input (usually YYYY-MM-DD).

What is the difference between business days and working days?

In most contexts, they are the same: days when most businesses operate, typically Monday to Friday excluding holidays. Some definitions also exclude days when a specific company is closed, but the general meaning is identical.

Why does my result differ from another calculator?

Likely because of differences in whether the start date is included, how holidays are handled, or what weekend days are assumed. Always check the assumptions of the specific tool you are using.

Related

• Time Value of Money: Formula and Calculation
• Calculate Time Lapse Duration: Formula and Examples
• Calculate Speed With Distance and Time

in start | Start date | - | 2025-01-06 | 0
in end | End date | - | 2025-01-17 | 0
in holidays | Holidays (comma-separated dates) | - | 2025-01-09, 2025-01-10 | 0
out business_days | Business days | days | max(0, floor((end - start) / 86400000) + 1 - 2 * floor((floor((end - start) / 86400000) + 1 + floor((start - 1) / 86400000) % 7) / 7) - count_holidays) | 0
out calendar_days | Calendar days | days | floor((end - start) / 86400000) + 1 | 0