WORKDAY Formula Not Working? Fix Excel Date Errors

If Excel’s WORKDAY formula is returning an error or an unexpected date, check that the start date is a real Excel date, the number of days is correct, and any holiday range contains valid dates. In Microsoft 365 for Windows, the basic formula is =WORKDAY(start_date,days,[holidays]); it counts Monday through Friday by default and skips dates listed as holidays.

What the WORKDAY function does

WORKDAY calculates a date a specified number of working days before or after a starting date. Its standard weekend is Saturday and Sunday, and the starting date itself is not counted when moving forward or backward. For example, adding five workdays to a Monday normally gives the following Monday, unless a listed holiday changes the count.

The function is useful for estimating delivery dates, project milestones, response deadlines, and processing schedules. It does not know your organization’s work calendar automatically: it assumes the standard weekend unless you use WORKDAY.INTL, and it skips only the holidays you provide. It also does not calculate working hours or account for half-days.

Check the formula syntax and the day count

The arguments are a start date, a number of workdays to move, and an optional range of holidays. Positive day counts move forward; negative counts move backward. A zero day count does not add or subtract workdays. If the day count contains a decimal, Excel truncates the fractional part, so use whole numbers rather than relying on a value such as 2.5.

With the start date in A2 as January 6, 2025, and the number of days in B2 as 5, enter =WORKDAY(A2,B2) in C2. The result is January 13, 2025: Tuesday through Friday are four workdays, and the following Monday is the fifth. Confirm that the cells referenced in your own formula contain the values you intend, especially if the day count is calculated elsewhere.

Extra spaces, a missing parenthesis, or an incorrect cell reference can also break a formula. In Microsoft 365 for Windows, select the formula cell and review the formula bar. Check that the function begins with an equals sign and that each argument is separated correctly. Excel installations using some regional settings expect semicolons rather than commas; if Excel rejects a comma-separated formula, use the argument separator configured for your region.

Make sure the start date is a real Excel date

Excel stores dates as numbers and displays them using a date format. A value that looks like a date may instead be text, especially if it was copied from a website, imported from a CSV file, or entered in a format Excel does not recognize in your regional settings. WORKDAY may then return #VALUE! or calculate from an unintended value.

Select the start-date cell and check the formula bar and number format. Changing the display format to Short Date can help reveal whether Excel recognizes the value, but formatting text as a date does not convert it. A simple check is to change the cell temporarily to General: a recognized date appears as a serial number. If the value remains text, import or convert it using a method appropriate to its format. Data > Text to Columns can help with consistently formatted imported dates; inspect the preview and choose the correct date order before completing the conversion.

Ambiguous text such as 3/4/2025 can mean March 4 or April 3 depending on regional settings. When building dates in formulas or preparing source data, use an unambiguous date value rather than assuming how Excel will interpret text. Also check the day-count cell: a number stored as text, an error from another formula, or a blank where a count was expected can lead to an error or a surprising result.

Check holidays and the range you supplied

The optional holidays argument should refer to cells containing actual date values. A holiday omitted from the range will be treated as a normal workday; an incorrect range may include unrelated dates or miss the final rows. Look at the range address in the formula and confirm that it covers the full holiday list, without headings or explanatory text. Blank cells in a holiday range are generally ignored, but text entries that resemble dates may not be interpreted as intended.

With January 6, 2025 in A2, 5 in B2, and January 9 and January 20, 2025 entered as real dates in D2:D3, use =WORKDAY(A2,B2,D2:D3) in C2. The result is January 14, 2025: January 9 is skipped, so the fifth working day falls on Tuesday, January 14. If you add or remove holidays over time, use a range that will include the whole list, or update the formula when the list changes.

For a recurring calendar, remember that WORKDAY does not infer public holidays from a country or region. Maintain the dates relevant to your own schedule, and check whether a holiday falls on a weekend. The function already skips Saturday and Sunday, so adding a weekend date as a holiday does not create an extra day off.

Use WORKDAY.INTL for a different weekend

If your working week does not follow the Saturday–Sunday pattern, use WORKDAY.INTL. It accepts the same start date, day count, and optional holiday list, plus a weekend setting. The numeric code 1 means Saturday and Sunday; code 7 means Friday and Saturday. It also supports a seven-character weekend pattern for more customized schedules, where each character represents a day of the week.

With Wednesday, January 8, 2025 in A2 and 3 in B2, enter =WORKDAY.INTL(A2,B2,7) in C2 for a Friday–Saturday weekend. The result is Monday, January 13, 2025: Thursday is the first working day, Sunday the second, and Monday the third. If your formula returns a date that conflicts with your normal workweek, confirm whether you need WORKDAY.INTL and whether its weekend code matches your actual schedule.

Understand common errors and unexpected results

#VALUE!: Check for text or invalid values in the start date, day count, or holiday cells. Imported dates and numbers stored as text are frequent causes.
#NUM!: Review unusually large day counts and date values outside Excel’s supported date range. Correct the inputs and check for a calculation that is pushing the result beyond a valid date.
#NAME?: Check the spelling of WORKDAY and any named ranges used for holidays. A misspelled function or an undefined name can trigger this error.
A date that seems one day off: Verify whether you expected the start date to count. WORKDAY moves by working days after or before the start date; it does not count the start date as day one when moving forward.
A weekend result: Check whether the formula references WORKDAY.INTL with an incorrect weekend code, or whether the displayed value is not the formula result you expected. The ordinary WORKDAY function skips Saturday and Sunday.

Another common misunderstanding is confusing WORKDAY with NETWORKDAYS. WORKDAY returns a date after moving by a number of workdays. NETWORKDAYS returns the number of working days between two dates. If you need a deadline date, WORKDAY is usually the relevant function; if you need to count weekdays in a period, investigate NETWORKDAYS instead.

Check formatting, recalculation, and workbook settings

WORKDAY returns a date value, but Excel may display that value as a number if the result cell is formatted as General or Number. Select the result cell and choose Home > Number Format > Short Date. If the cell displays #####, widen the column first; in some date-related cases, a negative value or invalid date can also prevent a date from displaying normally, so inspect the underlying value and inputs.

If the formula appears unchanged after you edit an input, check the workbook’s calculation setting. In Excel for Microsoft 365 on Windows, choose Formulas > Calculation Options > Automatic. If calculation is set to Manual, formulas may not update until recalculated. A formula displayed literally in the cell rather than evaluated may also mean the cell is formatted as Text, or that Show Formulas is enabled. Change a text-formatted formula cell to General, then re-enter the formula.

Excel workbooks can use either the 1900 or 1904 date system. When dates are copied between workbooks using different systems, their displayed dates can shift. If a result changes unexpectedly after copying sheets or data between files, compare the workbook date-system settings and verify the underlying dates rather than trying to compensate by adding or subtracting days.

A quick troubleshooting sequence

Work through these checks in order; they isolate most causes without changing the underlying schedule:

Read the formula bar and verify the function name, parentheses, separators, and cell references.
Confirm that the start date, day count, and holiday entries are valid values rather than imported text or errors.
Recount the days manually for a small example, remembering that the start date is not counted as the first workday.
Check whether Saturday–Sunday is the intended weekend. If not, use WORKDAY.INTL with the appropriate setting.
Format the result as a date, confirm calculation is automatic, and consider date-system differences if the workbook was copied.

For a useful test, temporarily try the formula with a known Monday and a small whole-number day count, without holidays. If that works, add the holiday range and any custom weekend setting back one at a time. This separates a problem in the basic calculation from a problem in the calendar data.

Frequently Asked Questions

Why does WORKDAY return a number instead of a date?
Excel stores dates as serial numbers. Format the result cell as a date using Home > Number Format > Short Date. The formula may be correct even if the cell is currently formatted as General.

Does WORKDAY count the start date?
No, not when moving forward or backward by a positive or negative number of workdays. For example, adding one workday to a Friday returns Monday under the standard weekend, unless Monday is in the holiday list.

Can WORKDAY exclude public holidays automatically?
No. Supply the dates you want excluded in the optional holidays argument. Excel does not automatically select holidays based on your country, employer, or calendar.

Why is my holiday not being skipped?
Check that the holiday is included in the referenced range and stored as a real date value. Also verify that the range has not stopped above the holiday’s row and that the date is not being interpreted differently because of regional settings.

What is the difference between WORKDAY and WORKDAY.INTL?
WORKDAY uses Saturday and Sunday as the weekend. WORKDAY.INTL lets you specify different weekend days or a custom pattern, which is useful for schedules that use a nonstandard working week.

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.