Excel WORKDAY with Holidays: Add Business Days Without an Off-by-One Error

Build a calendar with real Excel dates

Create the small setup below in a fresh worksheet. Enter the DATE formulas rather than pasting ambiguous strings such as 09/04/2026. Format A2, C2, and H2:H3 as yyyy-mm-dd so their displayed meaning is clear.

The two closure dates are invented for this exercise. Excel does not fetch public holidays automatically. For a real report, obtain the relevant workplace calendar, include observed closure dates, and keep its owner and year documented. An empty or outdated list changes the deadline.

A1: start_date        B1: workdays       C1: deadline
A2: =DATE(2026,9,4)    B2: 3
H1: excluded_dates
H2: =DATE(2026,9,7)
H3: =DATE(2026,9,10)
C2: =WORKDAY(A2,B2,$H$2:$H$3)

Trace the three counted working days

September 4 is the starting point. With a positive offset, it is not day one. September 5 and 6 are weekend days, September 7 is excluded, and September 8 is the first counted day. September 9 is second; the excluded September 10 is skipped, so September 11 is third.

This trace is more useful than repeatedly changing the formula until a date looks right. If your result differs, first inspect the source dates and count convention, then inspect the holiday range. A date stored as text may look identical to a numeric date in a formatted cell.

Choose an exclusive or inclusive start rule

For a promise phrased as “three business days after receipt,” the standard formula matches an exclusive start. For a three-day task whose first eligible date is day one, use the inclusive alternative below. It begins from the calendar day before the requested start, so the next eligible day can be counted.

The inclusive formula assumes B2 is a positive integer. It also handles a Saturday or holiday start by counting the first eligible date on or after that start. Simply subtracting one from B2 is insufficient when A2 itself is not a working day.

=WORKDAY(A2-1,B2,$H$2:$H$3)

Use WORKDAY.INTL for a custom weekend

WORKDAY assumes Saturday and Sunday are nonworking days. For a Friday/Saturday weekend, use WORKDAY.INTL and the quoted string "0000110". Its seven positions run from Monday through Sunday: 1 excludes that day and 0 allows it.

With a Thursday September 3 start, three subsequent workdays under that pattern, and the same two closures, the result is September 9. Friday and Saturday are skipped, Sunday September 6 counts as day one, Monday is a closure, Tuesday is day two, and Wednesday is day three. Keep the weekend pattern next to the report rather than leaving readers to infer it.

=WORKDAY.INTL(DATE(2026,9,3),3,"0000110",$H$2:$H$3)

Check holidays, copying, and result formatting

Use =ISNUMBER(A2) and =ISNUMBER(H2) as quick checks that these cells contain numeric dates, then inspect their displayed dates. A numeric result alone does not prove the correct day was entered. Keep the absolute holiday reference when filling C2 downward; otherwise the excluded range can slide to different cells.

WORKDAY returns an Excel date serial. If the result appears as a large integer, apply a date format instead of subtracting an arbitrary offset. Keep the result numeric when another formula or sort will use it; TEXT creates a display string.

Use whole-day offsets. Fractional offsets are truncated, so WORKDAY is not a calculator for shifts, half-days, or elapsed working hours. WORKDAY.INTL with an offset of zero returns the specified start date; it is not a general instruction to advance a weekend date to Monday.

Related help: Understand numeric date serials and display formats

Make the scheduling rule reviewable

Store the start, duration, holiday list, weekend rule, and computed deadline separately. This lets another reader explain the result without reverse-engineering a long formula. Before using a new year’s calendar, test a normal weekday, a weekend start, a closure start, and a date crossing year-end.

The downloadable setup reproduces this synthetic example. It does not include actual regional holidays or local working-time rules. Choose those inputs for your own workflow and verify one short interval by listing its counted dates.

Native desktop Excel 16.0 build 5569 executed the worksheet formulas in this example. The exclusive result was September 11 and the inclusive result September 9. Weekend-start, negative-offset, custom-weekend, zero-offset, fractional-offset and year-end controls also matched their expected dates. These are formula-engine checks on synthetic dates, not a verified regional holiday calendar or a recording of ribbon-menu actions.