TodayFree forever - no sign-up, no paid plans

How to Add Business Days to a Date for Delivery Dates and Deadlines

By Daniel Mercer · Updated October 27, 2026

Open the Business Days Calculator

Half of all business day questions point forward: an order ships in 5 business days, a quote is valid for 10, a payment lands in 3. Answering them means adding business days to a date - starting from a known day and counting forward over working days only, until you reach the number promised. This guide gives the method, works two examples (one of which lands directly on a holiday if you count carelessly), and shows the spreadsheet shortcut.

The method

Three rules do all the work. First, the start date is day zero - never count it, even if it is a working day, because the clock starts when the order, application or notice is made. Second, step forward one calendar day at a time and count the day only if it is a business day: Monday to Friday, and not a public holiday. Third, stop when your count reaches the number you were given; that date is the answer. If you start on a weekend, nothing changes - you still begin stepping from the next day, and the first business day you meet is day 1.

A useful shortcut for whole weeks: every block of 5 business days is exactly one calendar week, holiday-free. So 5 business days from a Wednesday is the next Wednesday, 10 is the Wednesday after that, and 15 the one after - then adjust for any holidays inside the span, each of which pushes the answer one day later. The business days calculator does the stepping for you with the federal holiday list built in; the method below is for when you want to see the working.

Worked example 1: five business days, no holidays

An order is placed on Wednesday, June 10, 2026, with delivery in 5 business days. Step forward: Thursday, June 11 is day 1; Friday, June 12 is day 2; the weekend is skipped; Monday, June 15 is day 3; Tuesday, June 16 is day 4; Wednesday, June 17 is day 5. Delivery date: Wednesday, June 17, 2026 - exactly one calendar week later, as the shortcut predicts.

Add business days to a date by counting forward over working days

Worked example 2: the holiday in the path

Same order, but the promise is 7 business days. The count runs June 11 (1), 12 (2), 15 (3), 16 (4), 17 (5) and 18 (6). The next calendar day is Friday, June 19 - Juneteenth, a federal holiday - so it is not counted. The weekend follows, and day 7 lands on Monday, June 22, 2026. Count weekends only, forgetting the holiday, and you would promise Friday, June 19: a delivery date on a day the carrier's offices and your customer are closed. This is the single most common forward-counting failure, and it happens precisely on the popular 7-to-10-business-day promises, because a span that long almost always contains a weekend and has a fair chance of containing a holiday too.

Check the path, not just the destination. Any span you quote should be scanned for the federal holidays that fall inside it - there is a full list in our guide to US federal holidays - and for observed shifts, since a holiday that falls on a weekend still closes the Friday or Monday next to it.

The spreadsheet shortcut: WORKDAY

In Excel and Google Sheets, the function is =WORKDAY(start_date, days, [holidays]). It follows exactly the rules above: the start date is not counted, weekends are skipped, and any holidays in the range you supply are skipped too. =WORKDAY(DATE(2026,6,10),7,Holidays) returns June 22, 2026, matching the hand count. Give it a negative number and it counts backwards, which is how you answer "what is the latest start date?" for a fixed deadline. For weekends that are not Saturday and Sunday, WORKDAY.INTL takes a weekend code in the same style as NETWORKDAYS.INTL. And if your question runs the other way - you have two dates and want the count between them - that is the days between calculator on the homepage or its business-days sibling linked at the top of this page.

Where forward counting is used

Delivery and shipping promises are the everyday case, and our guide on counting business days for shipping goes into carrier rules. The same method sets payment settlement dates (a transfer sent today arrives in 1 to 3 business days), quote validity windows, SLA response deadlines, and the start of cooling-off and return periods. In each case, write the resulting date down next to the promise. "7 business days" is an abstraction that two people can honestly read two ways in a holiday week; "Monday, June 22" is a fact they can both check.

Adding business days across a year boundary

Late December adds one more trap: the count can cross into a new year, where a fresh holiday list applies. Add 3 business days to Tuesday, December 29, 2026: Wednesday, December 30 is day 1, Thursday, December 31 is day 2, Friday, January 1, 2027 is New Year's Day and is skipped, the weekend follows, and day 3 lands on Monday, January 4, 2027. A count that only holds the 2026 list would stop on January 1 - a day when banks, courts and most offices are closed. Any forward count made in the last two weeks of a year should be checked against next year's holidays as a matter of routine.

Frequently asked questions

How do I add 5 business days to a date?

Start on the day after your date and count forward, counting only Monday to Friday days that are not holidays, until you reach 5. From a weekday, 5 business days normally lands on the same weekday the following week - one full week later - unless a holiday pushes it further.

Do I count the start date when adding business days?

No. The start date is day zero. The first business day after it is day 1. This matches the WORKDAY function in Excel and the way deadlines are counted in contracts and court rules.

What is the Excel formula to add business days to a date?

WORKDAY. =WORKDAY(start_date, number_of_days, holidays) returns the date that many business days after the start, skipping weekends and any holidays in the range you give it. WORKDAY.INTL does the same with a custom weekend.

What if the result lands on a holiday?

It cannot, if your holiday list is included in the count - the method skips holidays, so the landing day is always a working day. If you counted weekends only and landed on a holiday, move forward to the next business day.

How do I subtract business days from a date?

Count backwards with the same rules: step back one day at a time, counting only business days, until you reach the number you need. In Excel, give WORKDAY a negative number of days.

Related guides

How to count business days between two dates for a deadline

The deadline method: never count the start day, skip holidays, land on the last counted day.

How to calculate business days in Excel with NETWORKDAYS

Counting between two dates in a spreadsheet, WORKDAY included.

How to count business days for shipping and delivery estimates

Carrier transit days, cut-off times and promises that hold up.

10 business days - how many calendar days is that really

The honest conversion table for 1 to 30 business days, holidays included.

Daniel Mercer

Daniel Mercer builds and maintains the calculators on this site. He spent ten years in payroll and operations roles counting business days, notice periods and deadlines by hand, and writes these guides the way he would explain the count to a colleague - the rule first, a worked example second, and the common mistake called out before it happens.