WORKDAY in Excel: Calculate Dates Without Weekends

Formulas & functions · Updated November 20, 2026

In Excel, WORKDAY calculates a date a chosen number of working days before or after a start date, skipping Saturday and Sunday and, if supplied, listed holidays. Use WORKDAY.INTL when your weekend days differ from Saturday and Sunday, such as a Friday–Saturday weekend.

What WORKDAY does

WORKDAY is useful when a date needs to move by business days rather than calendar days. For example, adding five working days to a Monday does not mean adding five calendar days: the result is the following Monday, because the intervening Saturday and Sunday are not counted. A holiday list can exclude additional dates, such as a public holiday or a planned office closure.

The function counts forward for a positive number of days and backward for a negative number. It does not count the start date as day one. If the start date is Monday, adding one working day returns Tuesday. This makes WORKDAY a common choice for estimated delivery dates, project milestones, response deadlines, and processing schedules.

WORKDAY returns an Excel date value, not a written explanation of the calculation. Format the result cell as a date so that the returned value displays in a familiar form. Excel stores dates as serial numbers underneath; the displayed format changes how that number looks, not the underlying date calculation.

WORKDAY syntax and arguments

With the start date in A2, the number of working days in B2, and an optional holiday range in E2:E3, the basic pattern is:

=WORKDAY(A2,B2,$E$2:$E$3)

The arguments are:

  • start_date: The date from which Excel begins counting. Enter or calculate a genuine Excel date, rather than text that only looks like a date.
  • days: The number of working days to move. A positive number moves forward; a negative number moves backward. Excel truncates a fractional day value to an integer.
  • holidays: An optional range or array of dates to exclude, such as company holidays. If you do not need one, leave this argument out.

In the example pattern, dollar signs make the holiday range absolute. That is useful if you copy the formula down a column: A2 and B2 can change to A3 and B3, while the holiday range remains E2:E3. The dollar signs are not required if you will not copy the formula, but they help prevent accidental range shifts.

Build a working-day date calculation

Start with a small table so the inputs are easy to review. Put a start date in A2 and the required number of working days in B2. For a simple example, enter January 6, 2025 in A2 and 5 in B2. Without a holiday list, the result should be January 13, 2025: Tuesday through Friday account for four working days, and Monday, January 13, is the fifth.

With the start date in A2 and the day count in B2, enter this formula in C2 if there are no holidays to exclude:

=WORKDAY(A2,B2)

For the example inputs, C2 returns January 13, 2025. To make the calculation easier to audit, keep start dates, day counts, holiday dates, and calculated results in separate columns rather than embedding every value in the formula. You can then change an input and see the result update.

For a more realistic case, place January 10, 2025 in E2 and another holiday date in E3. With January 6 in A2 and 5 in B2, use the formula below in C2:

=WORKDAY(A2,B2,$E$2:$E$3)

The result is January 14, 2025. January 10 is excluded, so the five counted working days are January 7, 8, 9, 13, and 14. The holiday range can contain more dates than you currently need; blank cells in a referenced holiday range are ignored.

Exclude holidays correctly

WORKDAY does not know which dates are holidays for your organization, region, or project. You supply those dates in a worksheet range, typically one date per cell. Enter them as real Excel dates, and keep the list in a clearly labeled area or on a separate worksheet. The function treats each listed date as a nonworking day in addition to its normal weekend days.

A holiday that falls on a Saturday or Sunday does not create an extra skipped weekday: that date was already excluded as a weekend. If an organization observes a substitute day on a weekday, list the observed weekday itself. The function does not infer substitute holidays, regional rules, or annual holiday dates; those need to be maintained in the source list.

When formulas are copied down, use absolute references for the holiday range, as in the example, or use a named range such as Holidays. A named range can make a formula easier to read, but it is optional. To create one in Excel for Microsoft 365 on Windows, select the holiday cells and enter a name in the Name Box to the left of the formula bar. Check the range periodically so it includes every date relevant to the schedule.

Use WORKDAY.INTL for different weekends

WORKDAY assumes Saturday and Sunday are nonworking days. For a different weekly schedule, use WORKDAY.INTL, which adds a weekend argument. This function lets you choose a built-in weekend pattern or define working days with a seven-character string. The string runs from Monday through Sunday: 1 means a nonworking day and 0 means a working day.

For example, a business that treats Friday and Saturday as its weekend can use the pattern 0000110. With a Thursday, January 2, 2025 start date in A2 and 1 in B2, enter this formula in C2:

=WORKDAY.INTL(A2,B2,"0000110")

The result is Sunday, January 5, 2025: Friday and Saturday are skipped, so Sunday is the next working day. If the holiday list is in E2:E3, it can be added as the fourth argument: place the start date in A2, the day count in B2, and the holiday dates in E2:E3 before using the formula.

WORKDAY.INTL also accepts numeric weekend codes. Code 1 represents Saturday and Sunday, while code 7 represents Friday and Saturday. Codes 11 through 17 represent a single nonworking day, from Sunday-only through Saturday-only. A seven-character string is often clearer for unusual schedules because you can see each weekday’s status directly. Confirm that the pattern matches the actual workweek before relying on the results.

Dates, negative counts, and formatting

A negative day count is useful for finding a date a number of working days before a deadline. For example, a project plan might calculate a preparation start date by moving backward from a delivery date. The same holiday list and weekend rules apply in either direction. Remember that weekends and listed holidays are skipped on the way backward as well as forward.

Make sure that cells used as dates contain date values, not text. A value imported from another system may look like a date but be stored as text, which can cause a formula error or an unexpected result. If a result displays as a number such as 45670, the calculation may still be correct: select the result cell and choose a date format from Home > Number Format. Formatting does not repair text inputs, so verify the source values if the result itself is wrong.

WORKDAY uses the date system in the workbook and returns a date serial. Avoid typing dates in ambiguous formats such as 03/04/2025 when the regional settings could interpret the order differently. A clearly understood date entry or a date cell selected with Excel’s date controls reduces that risk. For imported data, check a few cells and confirm that Excel recognizes them as dates.

Common problems and how to fix them

  • The result is one day later than expected: Check whether the start date is being counted. WORKDAY begins moving from the start date and does not treat it as the first working day.
  • A holiday is not skipped: Check that the holiday is included in the referenced range and is a real date value. Also confirm that the formula’s range points to the correct cells.
  • The weekend is wrong: Standard WORKDAY always skips Saturday and Sunday. Use WORKDAY.INTL and check the weekend code or seven-character pattern if your schedule differs.
  • The formula shows an error: Check for invalid date inputs and ensure the holiday reference is valid. If a formula was copied from a website or another locale, your Excel regional settings may require a different argument separator; Excel’s formula bar can show the separator used by your installation.
  • The answer is a number: Apply a date number format to the result cell. Excel stores dates as numbers, so a general format can expose the serial value rather than a calendar date.

Also check whether a deadline should roll forward when its starting date is itself a weekend or holiday. WORKDAY’s job is to move by the specified count; it is not a substitute for defining a business rule about how an initial nonworking date should be handled. State that rule explicitly in the worksheet and choose the appropriate input date before interpreting the answer.

WORKDAY compared with NETWORKDAYS

WORKDAY answers a date question: “What date is this many working days before or after the start?” NETWORKDAYS answers a count question: “How many working days fall between these two dates?” NETWORKDAYS includes both the start and end dates in its count when they are working days, which differs from how WORKDAY advances from a start date.

For a nonstandard weekend, the related functions are WORKDAY.INTL and NETWORKDAYS.INTL. Choose based on the result you need: use a WORKDAY function when the output should be a date, and a NETWORKDAYS function when the output should be a number of working days. Both types can use a holiday list, and both need the weekend pattern specified when the default Saturday–Sunday schedule is not appropriate.

Where WORKDAY is useful—and what it does not model

Common uses include estimating a dispatch date after a processing period, setting a review date a fixed number of office days after submission, or finding the target start date before a milestone. For instance, if a team promises a response within three working days, WORKDAY can calculate a target date while excluding weekends and listed closures. The calculation is only as reliable as the input date, holiday calendar, and chosen workweek.

WORKDAY does not account for hours, shifts, partial working days, time zones, or a person’s individual availability. It works with whole-day date increments and a weekly weekend pattern. For schedules that depend on working hours or different calendars for different people, a more detailed scheduling model may be needed. Likewise, it does not decide whether a policy counts the submission day, so confirm the rule before treating its answer as an official deadline.

Frequently Asked Questions

Does WORKDAY count the start date?
No. It moves the specified number of working days away from the start date, so a Monday plus one working day returns Tuesday, assuming a standard weekend and no holiday.

How do I skip holidays in WORKDAY?
Put holiday dates in worksheet cells and provide that range as the optional third argument. The cells need to contain valid Excel dates, and the range must include all applicable holidays.

Can WORKDAY calculate backward?
Yes. Use a negative value for the days argument to move backward. The function skips its weekend days and any dates in the supplied holiday range in the backward calculation too.

How do I make Sunday a working day?
Use WORKDAY.INTL instead of WORKDAY. Set its weekend argument to a pattern or code that marks Sunday as a working day and accurately represents the days your organization closes.

Why does Excel show a number instead of a date?
Excel stores dates as serial numbers. Apply a date format to the result cell using Home > Number Format; if the calculation remains incorrect, check that the start date and holidays are actual date values rather than text.

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.