Excel WORKDAY Function Examples for Real Deadlines

Excel’s WORKDAY function calculates a date a specified number of working days before or after a starting date, skipping weekends and any holidays you provide. For example, with March 4, 2026 in A2, =WORKDAY(A2,5) returns March 11, 2026, because it counts five Monday-to-Friday workdays after the start date.

How the WORKDAY function works

The syntax is WORKDAY(start_date, days, [holidays]). The first argument is the starting date, the second is the number of workdays to move, and the optional third argument is a range or array of dates to treat as holidays. By default, Saturday and Sunday are not counted as working days. The function returns an Excel date value, so the result may need a date number format to display as a readable date.

The start date itself is not counted as the first day when you move forward or backward. If a task begins on Wednesday and takes one working day, the result is Thursday. If it takes five working days, Excel counts Thursday as day one and continues through the following Wednesday, skipping Saturday and Sunday.

A positive number of days moves forward to a later workday.
A negative number moves backward to an earlier workday.
A holiday in the optional list is skipped just like a weekend day.
The number of days should be an integer; a decimal is truncated to an integer.

WORKDAY is useful for calculating due dates, shipping estimates, project milestones, service-level deadlines, and follow-up dates when the rule is based on working days rather than calendar days.

Basic WORKDAY examples

For a simple formula, you can supply a date with Excel’s DATE function instead of referring to a cell. The layout assumption here is that no worksheet cells are required: the formula uses March 4, 2026 directly. =WORKDAY(DATE(2026,3,4),5) returns March 11, 2026. The five counted weekdays are March 5, 6, 9, 10, and 11.

Cell references make a deadline calculation easier to reuse. With a starting date in A2 and the required number of working days in B2, enter =WORKDAY(A2,B2). If A2 contains March 4, 2026 and B2 contains 5, the result is March 11, 2026. Change either input and the deadline recalculates automatically. Format the result cell as a date if Excel displays a number instead.

You can also use a negative number to find a date in the past. With a start date of March 10, 2026 in A2 and the offset -3 in B2, =WORKDAY(A2,B2) returns March 5, 2026. Excel moves backward through Monday, March 9; Friday, March 6; and Thursday, March 5. The weekend is skipped.

These examples use the standard Saturday-Sunday weekend. If your organization counts a different set of days as the weekend, use WORKDAY.INTL, covered below.

Exclude holidays from a deadline

To skip holidays, put actual Excel dates in a worksheet range and supply that range as the third argument. For example, suppose A2 contains March 4, 2026, B2 contains 5, and D2:D3 contain March 6 and March 9, 2026. With those cells holding real date values, =WORKDAY(A2,B2,$D$2:$D$3) returns March 16, 2026. March 6 and March 9 are excluded, as are the weekend dates March 7 and 8; the five counted workdays are March 5, 10, 11, 12, and 13, followed by March 16 as the fifth? Wait: counting carefully, March 5 is day one, March 10 day two, March 11 day three, March 12 day four, and March 13 day five. Therefore the result is March 13, 2026.

The result above illustrates why it is worth checking the count: the formula returns March 13, not March 16. When March 6 and March 9 are holidays, Excel skips them along with the weekend, then counts March 5, 10, 11, 12, and 13. The formula is recalculated from the holiday range, so adding or removing a date there updates the deadline.

Keep the holiday list as genuine date values, not text that merely looks like a date. A useful layout is one holiday per cell in a dedicated column, with a heading such as “Company holidays.” You can include dates from more than one year if the project might cross year boundaries; only dates that fall within the period being counted affect the result. Absolute references such as $D$2:$D$20 keep the holiday range fixed when copying the formula down a column.

Use WORKDAY.INTL for different weekends

Some businesses operate on weekends or use a weekend that does not fall on Saturday and Sunday. WORKDAY.INTL adds an optional weekend argument: WORKDAY.INTL(start_date, days, [weekend], [holidays]). The weekend can be specified with a numeric code or a seven-character string representing Monday through Sunday. In the string, 1 means a nonworking day and 0 means a working day.

For a Friday-Saturday weekend, the layout assumption is that A2 contains Thursday, March 5, 2026. The formula =WORKDAY.INTL(A2,2,7) returns Monday, March 9, 2026. Weekend code 7 means Friday and Saturday are nonworking days, so Sunday is day one and Monday is day two.

A weekend string gives more control over the pattern. With A2 containing Friday, March 6, 2026, =WORKDAY.INTL(A2,2,"0000011") returns Tuesday, March 10, 2026. The string marks Saturday and Sunday as nonworking; Monday is the first counted day and Tuesday is the second. This particular pattern matches the ordinary weekend, though the numeric code 1 is shorter for that schedule.

Excel also provides numeric weekend codes for individual weekend days and for pairs of consecutive weekend days. Check the code table in Excel’s function help when setting an uncommon schedule, because choosing the wrong code can silently shift every result. For a company with varying schedules by employee or location, make the weekend pattern an explicit input rather than burying it in a formula.

Build a reusable deadline column

A table can turn a one-off formula into a practical deadline tracker. For example, use columns for task, start date, working-day duration, and due date. Put a holiday list elsewhere on the sheet, then fill the deadline formula down the due-date column. The layout assumption is that the start date is in B2, the duration in C2, and holidays occupy H2:H20. Enter =WORKDAY(B2,C2,$H$2:$H$20) in D2; if B2 is March 4, 2026, C2 is 5, and the holiday range contains no dates during that period, D2 returns March 11, 2026.

For clearer maintenance, use descriptive table headings and make the holiday range easy to find. In Microsoft 365 for Windows, you can format a range as a table from Home > Format as Table. Excel table references can make formulas easier to read, although a regular cell-reference formula works well for a small tracker. On Mac, the same general table feature is available from the ribbon; the exact ribbon layout may vary with the Excel version. Excel for the web also supports ordinary WORKDAY formulas and date formatting.

When a calculated date is used as a commitment, distinguish the calculation from the policy behind it. WORKDAY only applies the dates and weekend pattern you give it. It does not know about office closures, regional calendars, cut-off times, or whether the starting date should count under a contract or internal rule.

WORKDAY compared with NETWORKDAYS

WORKDAY answers “What date is this many working days away?” NETWORKDAYS answers “How many working days are between these dates?” They are related but not interchangeable. NETWORKDAYS counts both the start and end dates when they are workdays, and it can also accept a holiday range.

With March 4, 2026 in A2 and March 11, 2026 in B2, the layout assumption for =NETWORKDAYS(A2,B2) is that the standard Saturday-Sunday weekend applies and there are no holidays to exclude. The result is 6: Wednesday, Thursday, Friday, Monday, Tuesday, and Wednesday. By contrast, =WORKDAY(A2,5) returns March 11 because it moves five workdays after March 4 and does not count the starting date.

Use WORKDAY when you need to calculate an end date from a start date and a duration. Use NETWORKDAYS when you need to measure the working-day span between two dates, such as checking how long a process actually took. For nonstandard weekends, the corresponding function is NETWORKDAYS.INTL.

Common problems and how to fix them

The result is a number. Excel stores dates as serial values. Apply a date format using Home > Number Format, or choose a date format from the Number group. The underlying result can still be correct even if it displays as a serial number.
A date that looks right is not recognized as a date. Text imported from another system may not be a valid Excel date. Re-enter it as a date or convert it before using WORKDAY. Regional date settings can also affect how text such as 04/05/2026 is interpreted.
The deadline is one day later than expected. Remember that the start date is not counted as day one. A one-workday duration starting on a Monday normally returns Tuesday, not Monday.
A holiday is not being skipped. Check that the holiday cell contains a date value, that the range in the formula includes that cell, and that the holiday is the same date as the one being skipped. A holiday entered as text may not match a real date.
The formula returns an error. Confirm that the start date is valid, the day count is numeric, and the holiday reference is a valid range. Also check that the weekend argument for WORKDAY.INTL is a permitted code or a seven-character pattern.
Copied formulas use the wrong holiday range. Lock the range with dollar signs, for example $H$2:$H$20, before copying the formula down.

When a result seems surprising, count the eligible dates manually for a short test period. That quickly reveals whether the issue is the start-date rule, the weekend selection, a holiday entry, or simply the displayed date format.

Frequently Asked Questions

Does WORKDAY count the starting date?
No. It moves the requested number of workdays from the start date. If A2 is a Monday and the day count is 1, =WORKDAY(A2,1) returns Tuesday, assuming there are no holidays and a standard weekend.

Can WORKDAY calculate a date in the past?
Yes. Use a negative number for the days argument. For instance, with March 10, 2026 in A2, =WORKDAY(A2,-3) returns March 5, 2026 under the standard weekend pattern.

How do I include public holidays?
Enter the holiday dates in worksheet cells and pass the range as the third argument to WORKDAY, or the fourth argument to WORKDAY.INTL. The dates must be valid Excel dates; WORKDAY does not retrieve a country’s public-holiday calendar automatically.

Can I make Sunday the only nonworking day?
Yes. Use WORKDAY.INTL with the seven-character weekend pattern "0000001", where the characters run Monday through Sunday and 1 marks a nonworking day. Add a holiday range as the fourth argument if needed.

Why does WORKDAY return a serial number instead of a date?
The formula returns a valid Excel date value, but the result cell may be formatted as General or Number. Apply a date format from the Home tab’s Number Format controls to display it as a calendar date.

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.