Excel WORKDAY Function Not Working? How to Fix It

If Excel’s WORKDAY function returns an error or an unexpected date, first check that the start date is a real Excel date, the number of days is numeric, and your holiday list contains valid dates. Then confirm that the default Saturday–Sunday weekend matches your schedule; use WORKDAY.INTL when it does not.

What WORKDAY Does—and What It Does Not Do

WORKDAY calculates a date a specified number of working days before or after a starting date. By default, it treats Saturday and Sunday as weekends and can also exclude dates in an optional holiday list. The starting date itself is not counted as one of the requested days. For example, adding one workday to a Friday normally returns Monday, unless Monday is a holiday.

With the starting date in A2 and the number of workdays to add or subtract in B2, enter =WORKDAY(A2,B2). If A2 contains May 15, 2026, a Friday, and B2 contains 1, the result is May 18, 2026, a Monday. A negative number counts backward; zero requests no additional workdays.

WORKDAY returns a date value, not a description of a work schedule or a count of weekdays between two dates. It does not know about company closures unless you provide them as holidays, and it cannot infer rotating shifts. Those distinctions explain many results that look wrong even when the formula is working as designed.

Check the Date Values and Cell Formatting

The most common underlying problem is that a date that looks correct is actually stored as text. Excel performs date calculations using serial numbers; applying a date format to text does not convert it into a usable date. Dates pasted from a website, imported from a CSV file, or entered in a format that conflicts with your regional settings are common sources of text values.

Select the start-date cell and inspect the formula bar. A date may be left-aligned by default when stored as text, but alignment is only a clue, not proof. A reliable check is to test the cell in a spare location. With the date in A2, use =ISNUMBER(A2). TRUE indicates a numeric value, as Excel dates normally are; FALSE suggests that the value is text or another nonnumeric entry. Convert or re-import the value as a real date rather than merely changing its display format.

For a date constructed from year, month, and day in separate numeric cells, use Excel’s DATE function. With the year in A2, month in B2, and day in C2, enter =DATE(A2,B2,C2). This avoids ambiguity between entries such as 4/5/2026, which can mean April 5 or May 4 depending on regional conventions. Check that the month and day columns contain numbers and that the resulting date is the one intended.

Also check whether the result cell is displaying a serial number such as 46160. That can be a perfectly valid date value shown with a General or Number format. Select the result cell and choose Home > Number Format, then select Short Date or another suitable date format. Formatting changes how the value appears; it does not change the calculation.

Resolve #VALUE!, #NUM!, and Other Errors

A #VALUE! error usually means one of the inputs cannot be interpreted as the required kind of value. Inspect the start date, the days argument, and every nonblank entry in the holiday range. A days cell containing text such as “five” is not equivalent to the number 5. A holiday typed as text may also fail to behave like a proper date. Replace text with numeric values and valid Excel dates, and remove stray text or error values from the holiday list.

A #NUM! error can point to a date outside Excel’s supported date range or an invalid date serial. It can also occur when a calculation would produce a date beyond the range Excel can represent. Check for unusually large day counts, negative serial values, and imported data that has been interpreted under an incompatible date system.

If the formula itself appears in the cell instead of a result, check whether the cell is formatted as Text. Change it to General, then edit the cell and press Enter so Excel evaluates the formula. Also check that Show Formulas has not been turned on; on Windows, Ctrl+` toggles that view. On Mac, the equivalent shortcut is Control+`; if that shortcut is unavailable on your keyboard, use the Formulas tab’s Show Formulas control.

When Excel rejects the formula as you enter it, verify the function name, parentheses, and argument separators. The formulas here use commas. Some regional configurations use a different list separator, often a semicolon, so use the separator Excel expects in your installation if a correctly structured formula is rejected. Do not replace the commas in a formula that Excel has already accepted.

Verify the Days Argument and the Expected Result

The days argument must represent the number of working days to move, not the number of calendar days. If you need to move forward by ten calendar days, adding 10 directly to a date is a different calculation from asking WORKDAY to move ten workdays. Weekends and listed holidays are skipped by WORKDAY.

For example, suppose A2 contains Thursday, December 24, 2026; B2 contains 2; and D2:D10 contains actual holiday dates, including December 25, 2026. With those cells, use =WORKDAY(A2,B2,$D$2:$D$10). The result is Tuesday, December 29, 2026: Friday is excluded as a holiday, Saturday and Sunday are weekends, Monday is the first counted workday, and Tuesday is the second. This example is a useful way to check whether the holiday range and day count are being applied as intended.

WORKDAY treats a fractional days value as a whole-number count by dropping the fractional part. Avoid relying on that behavior for business rules: make sure the days input is an integer, especially if it comes from another calculation. A value of 0.8 does not mean “most of one workday” in a date calculation.

One point that can surprise people is the treatment of the start date. If it is a workday and you request one workday, Excel moves to the next eligible workday; it does not count the start date as day one. If your organization counts the start date as the first day of a deadline period, adjust the number of days or the starting date to reflect that rule.

Check Weekends and Holidays

The standard WORKDAY function always uses Saturday and Sunday as the weekend. A correct formula can therefore return an unexpected result for a business that closes on different days. WORKDAY.INTL lets you specify a weekend pattern and, optionally, a holiday range.

With a start date in A2, a workday count in B2, and holiday dates in D2:D10, this formula sets Sunday and Monday as the weekend by using weekend code 2: =WORKDAY.INTL(A2,B2,2,$D$2:$D$10). Weekend codes select predefined weekly patterns. Alternatively, a seven-character weekend string lists Monday through Sunday, using 1 for a nonworking day and 0 for a working day. For a Saturday–Sunday weekend, that pattern is Monday through Friday working and Saturday and Sunday off. Make sure the string has exactly seven characters and matches the weekday order.

Holiday lists should contain actual date values, not labels such as “Christmas” or “Company day.” Keep the list in a consistent range, include all applicable closure dates, and avoid accidentally including an ordinary date. Blank cells in a holiday range are generally harmless, but text, errors, or dates shifted into the wrong year can cause confusion. Absolute references such as $D$2:$D$10 help keep the holiday range fixed when copying a formula down a column.

Check whether your organization’s definition of a working day includes local or regional holidays, half-days, or shutdown periods. WORKDAY excludes whole dates; it does not model partial business days. A company that observes a holiday on a different date from the official calendar needs its own holiday list.

Fix Copied Formulas and Calculation Settings

If the first row works but copied formulas do not, inspect the references. Relative references move as a formula is filled down. That is usually desirable for each row’s start date and day count, but a holiday range should often remain fixed with dollar signs. Compare a working row with a failing row and check that each reference points to the intended cells.

A result that does not update after you change an input may be caused by manual calculation mode. In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and select Automatic. You can also choose Formulas > Calculate Now to recalculate the workbook. If only the result is stale, recalculate and confirm that the formula refers to the cells you changed, rather than to a duplicate or older input range.

Excel for Mac uses the same WORKDAY and WORKDAY.INTL functions. Ribbon labels and keyboard shortcuts can differ slightly by release, but calculation settings are available from the Formulas tab. Excel for the web also supports these functions; if a formula behaves differently there, check whether the workbook contains unsupported features elsewhere, whether edits have finished syncing, and whether the input cells are truly dates.

When dates are copied between workbooks created with different date systems, the displayed dates can shift. Excel workbooks may use the 1900 or 1904 date system, which assigns different serial values to dates. If a copied date is consistently offset, compare the workbooks’ date-system settings and verify the actual date in the destination before trusting a deadline calculation.

Choose the Right Function for the Schedule

Use WORKDAY when the workweek is Monday through Friday and you need one date a specified number of working days from another. Use WORKDAY.INTL when weekend days differ or when you need to define a custom weekly pattern. Both can take a holiday list, so changing the weekend pattern does not mean giving up holiday exclusions.

These functions are related to, but not interchangeable with, NETWORKDAYS and NETWORKDAYS.INTL. WORKDAY returns a date after moving a specified number of working days. NETWORKDAYS counts working days between two dates. If your real question is “How many business days are between these dates?” use a NETWORKDAYS function instead of trying to make WORKDAY return a count.

For simple calendar-day arithmetic, ordinary addition may be more appropriate: adding 7 to a valid date advances seven calendar days and does not skip weekends or holidays. For schedules involving hours, shift rotations, partial days, or deadlines measured by business hours, WORKDAY alone is not enough. You need a model that represents those rules explicitly rather than treating every date as either wholly working or wholly closed.

Frequently Asked Questions

Why does WORKDAY return Monday when I expected Saturday?
WORKDAY skips Saturday and Sunday by default. If Saturday is a working day in your schedule, use WORKDAY.INTL and specify a weekend pattern that treats Saturday as working.

Does WORKDAY count the start date?
No. The start date is not counted as one of the requested workdays. A request for one workday moves to the next eligible date, subject to weekends and holidays.

Why is my WORKDAY result a number instead of a date?
The calculation may be correct while the result cell uses General or Number formatting. Apply a date format to display the serial value as a calendar date.

Can WORKDAY exclude more than one holiday?
Yes. Supply a range containing the holiday dates as the optional holidays argument. Make sure the cells contain valid Excel dates and that the range includes the full set of closures you intend to exclude.

Why does WORKDAY return the wrong result for a shift schedule?
The standard function assumes a repeating weekly workweek and excludes whole dates. Use WORKDAY.INTL for a different weekly weekend pattern; rotating shifts, partial workdays, and business-hour deadlines require additional scheduling logic.

A Quick Troubleshooting Checklist

Before rebuilding a formula, verify the basics in order. Confirm the start date is numeric, the days input is a number, and the result cell is date-formatted. Check the weekend assumption, holiday entries, and references in copied formulas. Finally, confirm calculation is automatic and recalculate the workbook. Most apparent WORKDAY failures come from one of these inputs or assumptions, rather than from the function being unavailable.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.