WORKDAY Formula in Excel: How It Calculates Business Dates

Formulas & functions · Updated November 20, 2026

Excel’s WORKDAY function returns a date a specified number of working days before or after a starting date, skipping Saturdays, Sundays, and any holidays you list. Its basic syntax is =WORKDAY(start_date, days, [holidays]); for example, with a start date in A2, a number of days in B2, and holiday dates in E2:E10, use =WORKDAY(A2,B2,$E$2:$E$10).

What the WORKDAY function is for

WORKDAY is useful when a schedule is based on business days rather than calendar days. You can use it to estimate a delivery date after dispatch, set a follow-up date after a certain number of working days, or calculate when a task is due after a business-day lead time. It returns a date value that Excel can use in further calculations, not merely a text label.

By default, Excel treats Saturday and Sunday as weekends. It does not automatically know which public holidays apply to your workplace or location. To exclude holidays, supply a range of dates in the optional third argument. If your usual weekend is different, use the related WORKDAY.INTL function instead.

Understand the arguments and counting rule

The function has three arguments. The first two are required; the holiday list is optional:

  • start_date is the date from which Excel begins counting. It can be a cell reference containing a real Excel date or a date created with a function such as DATE.
  • days is the number of working days to move. A positive number moves forward; a negative number moves backward.
  • holidays is an optional range or array of dates to treat as nonworking days, in addition to Saturdays and Sundays.

The start date itself is not counted as one of the requested working days. If Monday is the start date and you ask for one working day later, the result is Tuesday. This detail often explains why a result seems one day later than expected when someone is counting the start day as day one. If the start date is a weekend, counting proceeds to the next eligible working day for a positive offset.

The days argument is a count of working days, not calendar days. Excel ignores weekend days and listed holidays as it moves through the calendar. It truncates a fractional days value to an integer, so it is clearer and safer to supply a whole number.

Work through a business-day example

Suppose A2 contains January 5, 2026, B2 contains 10, and E2 contains January 19, 2026, a holiday for this example. Put the holiday date in E2 as a true Excel date, then enter this formula in C2:

With the start date in A2, the workday count in B2, and the holiday in E2, enter in C2: =WORKDAY(A2,B2,$E$2). The result is January 20, 2026.

Here is the count: January 6–9 are four working days, and January 12–16 add five, for a total of nine. January 17 and 18 are the weekend, while January 19 is excluded as a holiday. The tenth working day is Tuesday, January 20. Without the holiday in E2, the same formula structure would return January 19.

For a compact formula with dates typed into the formula rather than stored in cells, the layout assumption is that no worksheet date cells are used; this version is a standalone example: =WORKDAY(DATE(2026,1,5),10,DATE(2026,1,19)). It also returns January 20, 2026. Using cell references is generally easier to maintain when dates or day counts may change.

Set up and maintain a holiday list

A holiday list makes a workday calculation reflect the calendar you actually use. Enter one holiday per cell, preferably in a dedicated column, and point the formula at that range. For example, with the start date in A2, the offset in B2, and holiday dates in E2:E10, enter in C2: =WORKDAY(A2,B2,$E$2:$E$10). The dollar signs keep the holiday range fixed if you copy the formula down a column.

Use actual Excel dates in the list, not date-looking text. A quick way to create an unambiguous date is to enter it with the DATE function. The range can include dates that do not fall within the particular calculation period; they matter only if the workday calculation reaches them. If several teams or countries follow different holiday calendars, keep separate lists and refer each formula to the appropriate one.

Be precise about what counts as a holiday. A company closure, local observance, or regional public holiday should be included only if it is nonworking for the schedule being calculated. The function does not look up an official holiday calendar or infer a location from the workbook.

Use negative numbers and zero deliberately

A negative days value calculates a date in the past. This is useful for finding a preparation date a set number of business days before a deadline. For example, with the deadline in A2, the number of days to go back in B2, and the holiday dates in E2:E10, enter in C2: =WORKDAY(A2,-B2,$E$2:$E$10). If A2 is Monday, January 26, 2026, B2 is 5, and January 19 is the only relevant holiday, the result is Monday, January 19: counting backward gives January 23, 22, 21, 20, then skips the holiday on the 19th and reaches January 16. Correction: in this setup, January 16 is the fifth working day before January 26, so the result is January 16. This illustrates why it helps to verify the count across weekends and holidays.

When days is zero, WORKDAY returns the start date rather than advancing by a day. A zero offset can be useful when a formula is driven by a cell that may contain zero, but it does not mean “move to the next working day if the start date is a weekend.” If you need a policy that adjusts a weekend start date, state that rule separately and test the relevant cases.

Choose WORKDAY.INTL for a different weekend

WORKDAY always uses the standard Saturday–Sunday weekend. For a working week with different days off, use WORKDAY.INTL, whose syntax is =WORKDAY.INTL(start_date, days, [weekend], [holidays]). Its weekend argument can be a number representing a predefined weekend pattern or a seven-character string indicating working and nonworking days from Monday through Sunday.

For example, if A2 has the start date, B2 the offset, and E2:E10 the holiday dates, this formula explicitly uses the standard Saturday–Sunday weekend: =WORKDAY.INTL(A2,B2,1,$E$2:$E$10). The number 1 represents Saturday and Sunday as the weekend. Other numeric codes represent other two-day patterns; codes 11 through 17 represent a single weekend day, from Sunday through Saturday respectively. Check the pattern carefully before relying on it for a roster or service schedule.

A seven-character weekend string provides more control: each position corresponds to Monday through Sunday, with 1 marking a nonworking day and 0 marking a working day. For instance, a Monday-to-Friday workweek with Saturday and Sunday off is represented by 0000011. Use WORKDAY.INTL when those settings matter; adding weekend dates to the holiday list is not a good substitute for defining a recurring weekend pattern.

Format the result as a date and check inputs

Excel stores dates as numbers, and a formula result may appear as a serial number if its cell is formatted as General or Number. To display it as a date in Excel for Microsoft 365 on Windows, select the result cell and choose Home > Number Format, then select a date format. The exact date appearance depends on the chosen format and regional settings. In Excel for Mac or Excel for the web, the same general approach applies: select the cell and choose a date format from the number-format controls.

If a date is typed as text, Excel may interpret it differently according to regional settings, or it may not recognize it as a date at all. For a date assembled from year, month, and day values in A2, B2, and C2, use in D2: =DATE(A2,B2,C2). This produces a date value from those numeric components. Check that the cells used for start dates, holidays, and day counts contain the intended values before troubleshooting the result.

Common mistakes and unexpected results

  • Counting the start date: The start date is not day one of a positive offset. If a deadline convention counts the start date, account for that convention when setting the days value.
  • Forgetting holidays: Saturday and Sunday are excluded automatically, but public and company holidays are not. Add the applicable dates as the third argument.
  • Using text instead of dates: Date-looking text can be interpreted inconsistently. Use real Excel dates or construct dates with DATE.
  • Seeing a number instead of a date: The calculation may be correct; change the result cell’s number format to a date.
  • Using the wrong weekend pattern: WORKDAY cannot define a custom weekend. Switch to WORKDAY.INTL when the workweek differs from Monday through Friday.

Invalid or incompatible inputs can produce errors such as #VALUE!, while dates outside Excel’s supported range can produce #NUM!. If a formula returns an unexpected date without an error, check the start date, whether the offset is positive or negative, the holiday range, and the workbook’s date interpretation. For a business rule such as “deliver within five working days, counting the order date,” confirm how that rule defines day one before translating it into a formula.

How WORKDAY differs from related date functions

WORKDAY answers a forward-or-backward date question: “What date falls this many working days away?” NETWORKDAYS answers a count question: “How many working days are between these two dates?” Use the latter when you already have a start and end date and want the number of business days between them. Both functions can exclude a supplied holiday list, and NETWORKDAYS.INTL supports custom weekend patterns.

For a simple calendar-day offset, ordinary date arithmetic may be more suitable. With a date in A2 and a calendar-day count in B2, enter in C2: =A2+B2. That calculation includes weekends and holidays; it is not interchangeable with WORKDAY when a deadline is defined in business days. Choosing the function that matches the wording of the schedule prevents off-by-several-days mistakes.

Frequently Asked Questions

Does WORKDAY count the start date?
No. The start date is the reference point, not the first day in the requested count. A positive count of one returns the next working day after a weekday start date.

How do I exclude holidays in WORKDAY?
Enter holiday dates in worksheet cells and provide their range as the third argument, such as =WORKDAY(A2,B2,$E$2:$E$10), assuming the start date is in A2, the offset is in B2, and the holiday list is in E2:E10.

Can WORKDAY calculate a date before the start date?
Yes. Use a negative number for days. Excel counts backward, skipping the standard weekend and any dates in the optional holiday list.

How can I use a Sunday-to-Thursday workweek?
Use WORKDAY.INTL and specify the weekend pattern that applies to your schedule. Its weekend argument can define custom nonworking days; verify that the chosen pattern matches your calendar.

Why does WORKDAY show a number?
Excel stores dates as serial numbers. Select the result cell and apply a date format; the underlying calculated date can be valid even when the cell currently displays a number.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.