Add Business Days to Date: How It Works

This calculator adds a specified number of business days (Monday–Friday) to a starting date and returns the resulting calendar date. You enter a start date and the number of business days to add, and it skips weekends (and optionally holidays) to give you the correct end date. The result is useful for project deadlines, contract terms, shipping estimates, and any schedule that counts only working days.

Formula

The calculation works by advancing one calendar day at a time from the start date. For each step, it checks if the day is a weekday (Monday to Friday) and not in the holiday list. If it is a business day, the counter increments; if it is a weekend or holiday, the counter stays the same. The process continues until the counter equals the requested number of business days.

In symbols, let S be the start date, n the number of business days to add, and H the set of holiday dates. Define a function isBusinessDay(d) that returns true if d is Monday–Friday and d is not in H. Then the result R is the date such that exactly n business days occur in the interval (S, R] (or [S, R) if you count the start day as day 0). The calculator uses a simple loop: it starts at the day after the start date and moves forward, counting only days that satisfy isBusinessDay.

Worked Example

Using the default values: start date = 2025-01-06 (a Monday), add 10 business days, and one holiday on 2025-01-20 (Martin Luther King Jr. Day in the US).

1. Start at 2025-01-06. Count 0 business days added so far.
2. Move to 2025-01-07 (Tue) – business day, count = 1.
3. Continue through the week: Jan 8 (2), Jan 9 (3), Jan 10 (4).
4. Jan 11–12 are weekend, skip.
5. Jan 13 (Mon) – count = 5; Jan 14 (6); Jan 15 (7); Jan 16 (8); Jan 17 (9).
6. Jan 18–19 weekend, skip.
7. Jan 20 is a holiday, so it is not counted.
8. Jan 21 (Tue) – count = 10. Stop.

The result is 2025-01-21, which is 10 business days after Jan 6, accounting for the weekend and the holiday.

When to Use This Calculator

Business day calculations appear in many real-world scenarios:

• Contract deadlines: “Deliver within 15 business daysâ€� means weekends and holidays don’t count.
• Shipping and delivery: Many couriers promise delivery in business days, not calendar days.
• Financial settlements: Stock trades typically settle in T+2 business days.
• Human resources: Notice periods, leave requests, and payroll processing often use business days.
• Project planning: Task durations in Gantt charts often exclude weekends.

In each case, the key is that a business day is a day when most offices are open and work is normally done. For most countries, that’s Monday through Friday, but some regions have different weekends (e.g., Friday–Saturday in some Middle Eastern countries) or different public holidays.

How to Read the Result

The result is the calendar date that falls exactly n business days after the start date. If you add 0 business days, the result is the start date itself. If you add a positive number, the result is always a weekday (unless you include a holiday that falls on a weekday, but the result itself is never a weekend or holiday because those days are skipped).

For example, adding 1 business day to a Friday gives the following Monday (unless that Monday is a holiday, then Tuesday). Adding 5 business days to a Monday gives the next Monday, assuming no holidays in between.

The calculator also lets you enter a list of holidays (comma-separated dates in YYYY-MM-DD format). Those dates are excluded from the count. If you don’t enter any holidays, the calculation only skips weekends.

Common Mistakes and Misconceptions

One common mistake is confusing “business days� with “working days� when a company has a different schedule. For instance, some retail businesses work on weekends, but the standard financial definition uses Monday–Friday. Always confirm the definition used in your contract or context.

Another mistake is forgetting to account for holidays that fall on weekends. Many countries observe holidays on the nearest weekday if they fall on a weekend, but the actual holiday date may be different. For example, if a holiday falls on a Saturday, some companies give the following Monday off, but the official holiday date might still be Saturday. The calculator uses the dates you provide, so you must enter the actual days you want to exclude.

Also, be careful with the start date. If you want to count business days from today, and today is a weekend, the first business day is the next Monday. The calculator starts counting from the day after the start date, so if you enter a weekend start date, the first counted day is the following Monday.

Limitations of the Formula

The simple loop method is accurate for any reasonable number of business days, but it can be slow if you add thousands of days (though that’s rare). The calculator uses a loop, so it works correctly for positive numbers. It does not handle negative business days (subtracting business days) in this version.

The formula assumes a fixed set of holidays that you provide. It does not automatically know any country’s official holidays, so you must enter them manually. For international projects, you may need to consider different holiday calendars for different countries.

Also, the calculator treats all weekdays as business days. It does not account for half-days, company-specific closures, or emergency shutdowns. For those, you would need a more sophisticated schedule.

Alternatives and Related Calculations

If you need to find the number of business days between two dates, that’s a different calculation. You would count the weekdays between the dates and subtract holidays. Many spreadsheet tools have functions like NETWORKDAYS for that purpose.

If you need to add calendar days (including weekends), that’s a simple date addition. For example, adding 10 calendar days to Jan 6 gives Jan 16, regardless of weekends.

Some online tools and programming languages have built-in business day functions. For instance, Excel’s WORKDAY function adds business days to a date, and you can specify holidays. This calculator provides the same functionality in a simple web form.

Frequently Asked Questions

Q: What is a business day?
A: A business day is a day when most companies operate, typically Monday through Friday, excluding public holidays. It is used in contracts and logistics to define deadlines that don’t include weekends.

Q: Does this calculator count the start day as day 1?
A: No. The calculator starts counting from the day after the start date. If you enter a start date of Monday and add 1 business day, the result is Tuesday. To include the start day, you would add 0 business days to get the start date itself.

Q: How do I handle holidays that fall on weekends?
A: If a holiday falls on a weekend, you generally don’t need to exclude it because weekends are already skipped. However, if your company observes the holiday on a weekday (e.g., the following Monday), you should enter that observed date in the holiday list.

Q: Can I subtract business days?
A: This calculator only adds business days. To subtract, you could add a negative number, but the current version does not support negative input. For subtracting, consider using a different tool or manually counting backward.

Q: Why is the result sometimes a Tuesday instead of a Monday?
A: Because holidays are skipped. If a holiday falls on a Monday, the next business day is Tuesday. The calculator skips any date in your holiday list, so the result can shift to a later weekday.

Q: Are Saturdays and Sundays always excluded?
A: Yes, in this calculator. It assumes a Monday–Friday workweek. If your workweek is different (e.g., Sunday–Thursday), you would need a different calculator or manual adjustment.

Related

• How to Choose Dishwasher Size, Wash Programs & Water Use
• Word Processor File Formats Explained
• TypeScript for Loops: How to Stop with Break?

in start | Start date | - | 2025-01-06 | 0
in days | Business days to add | - | 10 | 0
in holidays | Holidays (comma separated YYYY-MM-DD) | - | 2025-01-20 | 0
out end_date | End date | - | add_business_days(start, days, holidays) | 0