How to Calculate Business Days Between Two Dates (Without Counting on Your Fingers)

Updated on February 26, 2026

Last month, my colleague sent a contract with a 10-business-day review window. She emailed it on a Thursday afternoon. I did what most people do — I counted 10 days forward in my head, landed on a Sunday, panicked slightly, and then just guessed Monday would be fine. It wasn't. The actual deadline was the Wednesday before.

If you've ever botched a deadline because you treated "10 business days" like "10 calendar days," this guide is for you. We're going to walk through exactly how working-day counting works, where people go wrong, and how to do it correctly every single time — whether you're doing it by hand, in a spreadsheet, or with a calculator tool.

Why the Simple "Subtract the Dates" Method Fails

The most intuitive approach is also the most dangerous one: take the end date, subtract the start date, and you have your answer. If today is June 10 and the deadline is June 20, that's 10 days, right?

Not even close — at least not in business terms.

Between June 10 and June 20, you'll have two full weekends (June 14–15 and June 21–22 don't count since June 20 is our endpoint, but June 14–15 does). That's 2 days to strip out immediately. Your "10-day window" suddenly becomes 8 working days. If there's a public holiday in there, it shrinks further.

The gap between calendar days and business days widens the longer the period. Over a 30-day span, you're typically losing 8–9 weekend days. Over a 90-day period, you're losing around 26. Deadlines, payment terms, legal windows, SLA timeframes — all of these almost universally mean business days unless explicitly stated otherwise.

Step 1: Pin Down Your Start and End Dates (And Be Specific About Inclusion)

Before you count a single day, answer this question: Is the start date itself counted as day one?

This sounds pedantic until you're on day 9 of a 10-day window and the other party insists the clock started the day before you thought. Different industries handle this differently:

  • Legal contracts often exclude the start date (the clock begins "the next business day after signing").
  • Project management usually includes the start date as day one.
  • Banking and payment terms vary — "Net 30" in invoicing almost always means 30 calendar days from invoice date, not business days, which is a separate trap entirely.

Get this agreed upfront. Write it down. The math you do next is useless if you and the other person are counting from different starting points.

Step 2: Count Total Calendar Days First

Take your end date and subtract your start date. You want the raw number of days in the interval. If you're doing this manually, a calendar is your best friend here — count every box from start to finish, inclusive or exclusive depending on what you established in Step 1.

Let's use a real example. Say you're counting business days from Monday, June 9 to Friday, June 27, including both endpoints.

Calendar days in that range: June 9 through June 27 = 19 days total.

Step 3: Subtract the Weekends

Now you need to strip out Saturdays and Sundays. This is where people often make arithmetic errors, so here's a reliable formula approach:

  1. Find how many full weeks are in your interval: divide total calendar days by 7 and take the whole number. That gives you the number of complete Saturday–Sunday pairs to remove.
  2. Handle the leftover days (the remainder) individually by checking what days of the week they fall on.

In our example: 19 days ÷ 7 = 2 full weeks (14 days) with 5 days remaining.

2 full weeks = 4 weekend days to subtract (2 Saturdays, 2 Sundays).

The remaining 5 days start from Monday June 9. Count forward: Mon, Tue, Wed, Thu, Fri — all weekdays. Zero additional weekend days to subtract.

Business days so far: 19 − 4 = 15 business days.

Step 4: Account for Public Holidays

This is the step most online calculators skip unless you specifically configure them, and it's where deadlines quietly bite people.

Public holidays are not universal — they depend on:

  • Country (obvious, but important)
  • State or region (in the US, for example, Juneteenth is federal but some states observe additional holidays; in India, public holidays vary significantly by state)
  • Industry (stock exchanges and banks often close on days when other offices stay open)
  • Company policy (some companies observe substitute holidays when a holiday falls on a weekend)

Manually check your date range against the official holiday calendar for your jurisdiction. If you find any public holidays that fall on weekdays within your window, subtract one business day per holiday.

In our June 9–27 example (US context), Juneteenth falls on June 19, a Thursday. Subtract one more day.

Adjusted total: 15 − 1 = 14 business days.

The Quick Formula (For When You Want to Check Your Work)

If you want a formula you can trust for a quick sanity check, here it is:

Business Days = Total Calendar Days − (Full Weeks × 2) − Extra Weekend Days − Public Holidays

Where "Extra Weekend Days" refers to any Saturday or Sunday that appears in your partial-week remainder at the beginning or end of the range.

This won't replace a careful walk-through for critical deadlines, but it's faster than counting manually when you just need a rough check.

How to Do This in a Spreadsheet

Excel and Google Sheets both have a function called NETWORKDAYS that does exactly this calculation. The syntax is:

=NETWORKDAYS(start_date, end_date, [holidays])

The third argument is optional but powerful — you can create a separate column or sheet listing all your relevant public holidays and reference that range. The function will automatically exclude those dates.

One important note: NETWORKDAYS includes both the start and end date in its count. If your convention excludes the start date, use =NETWORKDAYS(start_date+1, end_date, [holidays]) instead.

There's also NETWORKDAYS.INTL if your working week isn't Monday–Friday. This variant lets you define custom weekend days — useful if you're working with a jurisdiction where Friday–Saturday is the standard weekend, or if your team works Tuesday through Saturday.

Common Mistakes That Cause Real Problems

Mistake 1: Treating the count as symmetric. "10 business days from June 10" and "the business day that is 10 working days before June 24" are not always the same date. When you're calculating backwards from a deadline, count backwards explicitly — don't just subtract 14 calendar days and hope.

Mistake 2: Ignoring time zones for the start date. If a contract is signed at 4:58 PM on a Friday in New York, but the other party is in London where it's already Saturday, your "start date" may be disputed. International agreements should specify a reference time zone explicitly.

Mistake 3: Assuming holidays are consistent year to year. Holidays that fall on weekends get observed on different weekdays each year. The US July 4th that falls on a Saturday might be observed on Friday July 3rd — which means that day is a holiday even though it doesn't look like one on a standard calendar.

Mistake 4: Forgetting half-days. Many offices close early the day before a major holiday. This doesn't reduce your business day count, but it absolutely affects whether someone can actually respond or act before a deadline.

When You Need a Quick Answer Right Now

For one-off calculations where you don't want to open a spreadsheet, a dedicated date calculator tool is the fastest option. Look for one that:

  • Lets you specify a country and optionally a state/province for holidays
  • Shows you which holidays it's subtracting so you can verify
  • Handles both "how many business days between X and Y" and "what date is N business days from today"

The second use case — "what date lands N business days from now" — is arguably more useful day-to-day. You know you need to respond within 5 business days; you want to know the specific calendar date, not just a count.

Putting It All Together

Here's the complete mental checklist for any business-day calculation:

  1. Confirm whether the start date is included or excluded from the count.
  2. Count total calendar days in the range.
  3. Subtract weekends: (full weeks × 2) + any weekend days in the partial week remainder.
  4. Look up public holidays for the relevant country, state, and industry — subtract any that fall on weekdays within your range.
  5. Double-check with NETWORKDAYS in a spreadsheet if the deadline is high-stakes.
  6. If time zones are involved, pin down a reference zone and make sure both parties agree on it.

Business-day counting is one of those things that feels trivial until it costs you a penalty, a missed filing, or an awkward conversation with a client who got a different number than you did. The math itself is genuinely simple once you internalize the steps — the real skill is not skipping any of them.

Count carefully, verify once, and write the final date on your calendar. Your future self will thank you.