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_dateis 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 asDATE.daysis the number of working days to move. A positive number moves forward; a negative number moves backward.holidaysis 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:
WORKDAYcannot define a custom weekend. Switch toWORKDAY.INTLwhen 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
- How to Freeze Rows and Columns in Excel
- Freeze in Excel: Keep Rows and Columns Visible on Screen
- Freeze a Specific Row in Excel: Steps, Limits, and Tips
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula: Check If a Value Is in a ListIf the value to check is in A2 and your list is in D2:D10, use =IF(COUNTIF($D$2:$D$10,A2)>0,"In list","Not in…
- Excel Formula to Randomly Select From a ListWith names in A2:A20, use =INDEX(A2:A20,RANDBETWEEN(1,ROWS(A2:A20))) to return one randomly chosen entry. The formula selects a row position…
- Sumifs with date range?Learn how SUMIFS handles dates, boundaries, months, extra criteria, and common errors, with clear Excel examples to help…
- Excel Time Card Formula: Track Hours and OvertimeFor a basic Excel time card, enter a start time in B2, an end time in C2, and…
- Divide in Excel Without a Function: Use the / OperatorTo divide in Excel without a function, enter a formula that starts with an equals sign and uses…
- Vending Machine Inventory Spreadsheet: Setup and FormulasA vending machine inventory spreadsheet tracks what is loaded, what remains, what sold, and what needs restocking. Start…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.