Add Days Excluding Weekends: How It Works

This calculator adds a number of days to a start date and skips Saturdays and Sundays, returning the first weekday that falls after the given number of working days. You enter a start date and a count of days to add, and it gives you the resulting date, plus the total elapsed calendar days and the number of weekend days skipped. The calculation uses a straightforward counting method that matches how most business-date tools work.

Formula

The core formula counts forward one day at a time from the start date. For each day counted, if the day of the week is Monday through Friday, it increments the working-day counter. When the counter equals the number of days you asked to add, the current date is the result.

Let:

• D = start date
• N = number of working days to add
• W = day of week (1 = Monday, 7 = Sunday)

In words: repeat N times — advance D by one day; if W is 1–5, keep the day; if W is 6 or 7, skip it and continue. The final date is the answer.

For large N, a direct formula exists: add 7 × floor(N / 5) days, then handle the remainder (N mod 5) by checking the starting weekday and skipping a weekend if needed. That shortcut is what most spreadsheet functions like WORKDAY use.

Worked Example

Using the default values: start date = Monday, January 6, 2025, and N = 10 working days.

1. Count 10 weekdays forward from Jan 6.
2. Week 1: Jan 6 (Mon), Jan 7 (Tue), Jan 8 (Wed), Jan 9 (Thu), Jan 10 (Fri) — that’s 5 days.
3. Week 2: Jan 13 (Mon), Jan 14 (Tue), Jan 15 (Wed), Jan 16 (Thu), Jan 17 (Fri) — that’s 5 more, total 10.
4. Result: Friday, January 17, 2025.

The elapsed calendar days are 11 (Jan 6 to Jan 17 inclusive), and the weekend days skipped are 2 (Jan 11 and Jan 12).

When to Use This Calculation

This is the standard “business days� or “working days� calculation used in project planning, shipping estimates, HR leave tracking, and contract deadlines. If you are told “delivery in 10 business days� or “you have 5 working days to respond,� this is the date you need.

It assumes a Monday–Friday workweek. Many organizations have holidays off, but holidays are not automatically skipped because they vary by country, region, and company. If you need to exclude holidays, you must provide a list of dates to skip — this calculator does not include any holiday calendar.

How to Choose the Right Start Date

The start date matters. If you start on a weekend, the calculator counts from that date, but since weekends are skipped, the first working day after the weekend is effectively day 1. For example, adding 1 day to a Saturday gives the following Monday.

If you need to include the start date as day 1 (e.g., “you have 5 days from today�), set the start date to today and add 4 days instead of 5, or adjust your input accordingly. Many business tools treat “5 business days from today� as 5 days after today, not counting today itself.

Common Mistakes and Misunderstandings

• Confusing “business daysâ€� with “calendar days.â€� A 10-business-day deadline is usually two calendar weeks, not 10 days.
• Forgetting that the start date itself is not counted. If you add 1 day to a Monday, you get Tuesday, not Monday.
• Assuming holidays are skipped. This calculator only skips weekends. Add holidays manually by extending the number of days or using a dedicated holiday-aware tool.
• Using “end of dayâ€� vs. “start of day.â€� The result is a date, not a time. If the deadline is end of business, you still have until that date’s close.

Limits and Edge Cases

The calculation works for any date range, but note:

• It does not account for time zones. A date is a date; if you cross a time zone, the exact moment may differ.
• It assumes the Gregorian calendar, which is the standard in most of the world.
• It does not handle “skip a specific weekdayâ€� (e.g., only Mondays and Wednesdays). That requires a different tool.
• It does not handle “add N days excluding weekends and holidaysâ€� automatically — you must adjust for holidays yourself.

For very large N (e.g., 1000 business days), the direct formula is accurate, but the day-by-day method is simpler to verify manually.

Alternatives and Related Calculations

If you need more control, consider these variations:

• Add calendar days: simple date arithmetic, no skipping.
• Add business days with holidays: requires a holiday list; many spreadsheet functions allow this.
• Count business days between two dates: the reverse problem — how many weekdays fall in a given range.
• Add days excluding a specific weekday: e.g., “every Tuesday and Thursdayâ€� — a custom recurrence.

For most everyday needs, the weekend-skipping version is the right default.

Frequently Asked Questions

Does “add 10 days� mean 10 calendar days or 10 business days?

It depends on context. In legal and HR documents, “days� often means calendar days unless “business days� is specified. This calculator specifically adds working days, so use it when the context is business or work-related.

What if the start date is a weekend?

The calculator still counts from that date, but since weekends are skipped, the first weekday after the weekend is day 1. For example, adding 1 day to a Saturday gives the following Monday.

How do I include holidays?

This calculator does not skip holidays. To include them, you can manually add extra days to your input (e.g., add 1 more day for each holiday that falls in the range), or use a tool that accepts a holiday list.

Why does adding 5 business days sometimes take 7 calendar days?

Because a 5-day workweek is Monday–Friday. If the start is Monday, 5 business days later is the following Monday (7 calendar days later). If the start is Friday, 5 business days later is the next Friday (7 calendar days later).

Is there a formula I can use in Excel?

Yes, Excel’s WORKDAY function does exactly this: =WORKDAY(start_date, days). It skips weekends and optionally holidays if you provide a range. This calculator uses the same logic.

What is the maximum number of days I can add?

There is no practical limit for date arithmetic, but very large numbers (e.g., 100,000 days) will produce dates far in the future. The calculation remains accurate as long as the date system supports it.

Related

• How Is Pace Calculated? Running Pace Explained
• Converting pKa to pH: Formula and How to Use It
• Ancient DNA Sampling: Preventing Contamination

in d | Start date | - | 2025-01-06 | 0
in n | Days to add | days | 10 | 0
out end | End date | - | add_weekdays(d, n) | 0
out elapsed | Elapsed calendar days | days | end - d | 0
out weekends | Weekend days skipped | days | elapsed - n | 0