WORKDAY Function in Excel: Dates, Holidays and Examples

Formulas & functions · Updated November 20, 2026

Use Excel’s WORKDAY function to return a date a specified number of working days before or after a starting date. With a start date in B2 and the number of working days to add in B3, enter =WORKDAY(B2,B3); add a holiday-date range as a third argument when those dates should not count.

What the WORKDAY function does

WORKDAY is a date function for scheduling tasks, setting delivery targets, estimating due dates, and answering questions such as “What date is five business days after this one?” It moves forward or backward across the calendar while skipping Saturday and Sunday. You can also tell it which dates are holidays or other nonworking days.

The function returns an Excel date value, not a written explanation of the calculation. A result may appear as a number if the result cell is formatted as General; applying a date format displays it as a calendar date. WORKDAY does not decide what counts as a working day for your organization. By default, it assumes a Monday-to-Friday workweek and treats only the dates you supply as holidays.

Understand the arguments

The function’s syntax is WORKDAY(start_date, days, [holidays]). The brackets indicate that holidays is optional; do not type the brackets into a formula. The arguments mean:

  • start_date: The date from which Excel begins counting. Use a genuine Excel date value, such as a date entered into a cell, rather than an ambiguous text string.
  • days: The number of working days to move. A positive number moves into the future; a negative number moves into the past. Zero returns the start date.
  • holidays: An optional reference to one or more dates that should be skipped in addition to the weekend. You can supply a cell range or a date value.

The starting date itself is not counted as the first working day when you add a positive number. For example, adding one working day to a Wednesday normally returns Thursday, not Wednesday. If the start date is a weekend or holiday, the function moves past nonworking dates as it counts. That detail matters when a policy says the start date itself should count as day one; confirm the counting rule before building a deadline calculation.

Calculate a date with a basic example

First put a real date in B2 and a whole number of working days in B3. For example, enter March 4, 2026 in B2 and 5 in B3. With that layout, use =WORKDAY(B2,B3). The result is March 11, 2026: Thursday March 5 is day one, Friday March 6 is day two, and Monday through Wednesday March 9–11 are days three through five.

To calculate backward, keep the same layout but enter -5 in B3. The formula =WORKDAY(B2,B3) then returns February 25, 2026. Counting back from March 4, the prior working days are March 3, March 2, February 27, February 26, and February 25. Saturday and Sunday are skipped.

To enter the calculation in Excel for Microsoft 365 on Windows:

  1. Enter the starting date in a cell and the number of working days in another cell.
  2. Select the cell where you want the answer, type the formula using those cell references, and press Enter.
  3. If the result looks like a number, select the result cell and choose a date style from Home > Number Format.

The function is also available in Excel for Mac and Excel for the web. The same formula works in those versions. Depending on regional settings, Excel may expect semicolons rather than commas between arguments; the examples here use the standard comma-separated syntax.

Exclude holidays from the calculation

WORKDAY will not infer public holidays, company closures, or vacation days. List each date to exclude in worksheet cells, ideally in one clearly labeled column, and refer to that range in the formula. For example, with March 4, 2026 in B2, 5 in B3, and March 9, 2026 in D2, enter =WORKDAY(B2,B3,D2:D2). The result is March 12, 2026: March 9 is skipped, so the fifth working day falls on Thursday.

For a longer calendar, place all relevant holiday dates in D2:D20 and use =WORKDAY(B2,B3,D2:D20) with the same start-date and day-count layout. The range can include dates for multiple years if needed. Keep the entries as actual Excel dates and check that the range covers the full period the calculation could reach. Blank cells in a holiday reference are ignored; dates that fall on an already excluded weekend do not create an extra skipped day.

A holiday list is a model of a particular calendar, not a universal calendar. If different locations, teams, or contracts observe different closures, use the appropriate list for each calculation. Also decide whether an observed holiday on a weekend is represented by its actual date, a substitute weekday, or both, according to the applicable schedule.

Use a nonstandard weekend

If the working week does not run Monday through Friday, use WORKDAY.INTL. It has the same date and day-count purpose, plus an argument for defining weekends. You can use a weekend number or a seven-character text pattern, with the characters ordered Monday through Sunday. In that pattern, 1 marks a nonworking day and 0 marks a working day.

For a Friday-and-Saturday weekend, the pattern is 0000110: Monday through Thursday are workdays, Friday and Saturday are off, and Sunday is a workday. With March 4, 2026 in B2, 5 in B3, and March 9, 2026 in D2 as a holiday, use =WORKDAY.INTL(B2,B3,"0000110",D2:D2). The result is March 12, 2026. The weekend pattern changes which weekdays are skipped; the holiday range still excludes the listed holiday.

WORKDAY.INTL also accepts preset weekend codes. For example, code 1 represents Saturday and Sunday, while code 7 represents Friday and Saturday. For a custom schedule, check the function’s documented code order or use a seven-character pattern to make the intended days explicit. A pattern must contain seven characters, one for each day of the week.

WORKDAY compared with related functions

WORKDAY answers a forward-or-backward date question: “What date is this many working days away?” NETWORKDAYS answers a different question: “How many working days are between these two dates?” NETWORKDAYS counts both endpoint dates when they are workdays, so its answer may not match the offset value used in a WORKDAY calculation.

For example, with March 4, 2026 in B2 and March 11, 2026 in B3, enter =NETWORKDAYS(B2,B3). The result is 6, counting March 4, 5, 6, 9, 10, and 11. Yet WORKDAY(B2,5) returns March 11 because the starting date is not included among the five days added. NETWORKDAYS also accepts an optional holiday range, and NETWORKDAYS.INTL provides custom weekend definitions.

Choose the function based on the result you need: use WORKDAY or WORKDAY.INTL to find a date after a specified working-day offset; use NETWORKDAYS or NETWORKDAYS.INTL to count working days across a date interval. Neither function calculates elapsed hours or automatically handles partial workdays.

Common problems and checks

  • The result appears as a serial number: The calculation may be correct, but the cell is displaying a number format. Apply a date format from Home > Number Format.
  • The result is one day later or earlier than expected: Check whether your process counts the start date as day one. WORKDAY excludes the start date when counting an offset.
  • A holiday is not skipped: Confirm that the holiday cell contains a real date, that the formula refers to the correct range, and that the date falls within the range’s listed dates.
  • The formula returns an error: Check that the start date is a valid date, the day count is numeric, and the optional holiday reference is valid. Text that resembles a date can be interpreted differently under different regional settings.
  • The custom weekend is wrong: For a text pattern, count exactly seven characters and verify that they run Monday to Sunday. A 1 means off, not on.

When a result drives a deadline, inspect the inputs as well as the formula. A correctly calculated date can still be wrong for the situation if the holiday list is incomplete, the workweek differs by location, or the start-date counting policy was misunderstood.

Practical uses and limitations

WORKDAY is useful for setting a response deadline a fixed number of business days after a request, estimating a ship date after processing time, or finding a review date before a milestone. For example, a service team can store the request date in one column, its response target in another, and a shared holiday list elsewhere, then calculate due dates consistently. If the target duration varies by row, reference the row’s day-count cell rather than typing a fixed number into every formula.

The result is a calendar date; WORKDAY does not know about opening hours, time zones, cutoff times, weekends that change by season, or rules such as “the next business day unless it is after 3 p.m.” Those require additional logic and clearly defined policies. For date-and-time commitments or complex shift calendars, a simple working-day offset may not be enough. Validate important results against the schedule or policy that governs the real deadline.

Frequently Asked Questions

Does WORKDAY count the start date?
No. The starting date is not counted as one of the working days added or subtracted. If the start date should count as day one, establish how weekends and holidays affect that rule before adapting the calculation.

Can WORKDAY calculate a date in the past?
Yes. Enter a negative number for days. For example, with a start date in B2 and the number of working days to go back in B3, =WORKDAY(B2,B3) returns the earlier date when B3 contains a negative number.

Does WORKDAY automatically know public holidays?
No. Supply the relevant holiday dates as the optional holidays argument. Excel does not automatically choose a country’s public-holiday calendar for this function.

Can I use WORKDAY with a Sunday-to-Thursday workweek?
Yes. Use WORKDAY.INTL and define Friday and Saturday as nonworking days, either with its matching weekend code or the seven-character pattern 0000110.

Why does WORKDAY show a number instead of a date?
Excel stores dates as serial values. Format the result cell as a date using Home > Number Format to display it as a calendar date.

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.