Use Excel’s WORKDAY function to calculate a date a chosen number of working days before or after a start date, excluding weekends and any holidays you specify. With a start date in A2 and a number of workdays in B2, enter =WORKDAY(A2,B2); the result is a date, not a count of days.
What WORKDAY does
WORKDAY is useful when a deadline, delivery, or follow-up is measured in business days rather than calendar days. It counts Monday through Friday as working days by default, skips Saturday and Sunday, and can also skip dates in a holiday list. The start date itself is not counted as day one: a positive count begins with the next working day.
For example, suppose A2 contains March 4, 2026, a Wednesday, and you want a date five working days later. With that date in A2, enter =WORKDAY(A2,5). The five days counted are Thursday, March 5; Friday, March 6; Monday, March 9; Tuesday, March 10; and Wednesday, March 11. The result is March 11, 2026.
The function’s syntax is WORKDAY(start_date,days,[holidays]). The square brackets in that description mean the holidays argument is optional; do not type the brackets into a formula. Start_date is the date to count from, days is the number of working days to move, and holidays is an optional date or range of dates that should not count as workdays.
Enter and check a basic formula
Put the starting date in one cell and the number of business days to add or subtract in another. For a concrete layout, A2 contains March 4, 2026, and B2 contains 5. Enter =WORKDAY(A2,B2) in C2. C2 returns March 11, 2026, assuming the standard Saturday-and-Sunday weekend and no holidays.
Format the result cell as a date if Excel shows a number instead. Select the cell, then choose Home > Number Format and select a date format. Excel stores dates as serial numbers, so a number can be a valid calculated date even if it is not yet displayed in a familiar calendar format. The displayed order of month and day depends on the workbook’s regional settings.
A positive days value moves forward; a negative value moves backward. With March 11, 2026, in A2, enter =WORKDAY(A2,-3) to move back three working days. The result is March 6, 2026: Tuesday, March 10 is one day back, Monday, March 9 is two, and Friday, March 6 is three. A zero offset returns the start date, provided it is a valid date.
Exclude holidays from the calculation
WORKDAY does not know which dates are public holidays, company closures, or personal nonworking days. Keep those dates in worksheet cells and pass the range as the third argument. This makes the schedule easier to review and update than embedding dates directly in each formula.
For example, put March 9, 2026, in C2 as a holiday, and put March 4, 2026, in A2. With those dates in place, enter =WORKDAY(A2,5,C2:C2). The result is March 12, 2026: the function skips Saturday and Sunday as usual and also skips the holiday on Monday, March 9.
For a reusable list, enter each holiday as a real Excel date in a column such as F2:F20. With the start date in A2, the day count in B2, and holiday dates in F2:F20, enter =WORKDAY(A2,B2,$F$2:$F$20). The dollar signs keep the holiday range fixed if you copy the formula down a column. Blank cells in a holiday range do not need to be filled with placeholder dates.
- Use one date per cell so the list is easy to sort, check, and maintain.
- Check that the entries are actual Excel dates rather than text that only looks like dates.
- Include all closures relevant to the schedule, such as an office shutdown, if they should be treated as nonworking days.
- A holiday that falls on a weekend does not create an additional workday to skip, because that date was already excluded as a weekend.
Set a different weekend pattern
If your workweek does not run Monday through Friday, use WORKDAY.INTL. It accepts a weekend setting as well as an optional holiday range, so it can model schedules such as Sunday through Thursday or a single weekly rest day. Its syntax is WORKDAY.INTL(start_date,days,[weekend],[holidays]).
The weekend argument can be a number representing a standard weekend pattern or a seven-character string that describes Monday through Sunday. In the string, 1 means a nonworking day and 0 means a working day. For example, the string 0000110 marks Friday and Saturday as nonworking days and the other five days as working days.
With March 4, 2026, in A2 and a Friday-Saturday weekend, enter =WORKDAY.INTL(A2,5,"0000110"). It returns March 11, 2026: the five counted workdays are Thursday, March 5, Sunday, March 8, Monday, March 9, Tuesday, March 10, and Wednesday, March 11. To use that pattern with holidays listed in F2:F20, enter =WORKDAY.INTL(A2,5,"0000110",F2:F20).
Make sure the seven characters are in Monday-to-Sunday order. A string with the wrong position for a weekend day can produce a plausible-looking but incorrect deadline. If you use a numeric weekend code instead, check Excel’s function help for the code that matches your schedule.
Use WORKDAY in practical schedules
A common use is calculating a due date from a request date and a service target. Put each request date in column A, the target number of working days in column B, and the relevant holiday dates in a separate list. With those inputs, enter =WORKDAY(A2,B2,$F$2:$F$20) in C2 and fill it down. Each row then calculates its own deadline while using the same holiday calendar.
The same approach works for project planning. If a task begins on a known date and takes a set number of workdays, WORKDAY can estimate its finish date. A useful spreadsheet keeps the assumptions visible: the start date, duration, weekend pattern, and holiday list should be clear to anyone reviewing the schedule. The result is a date estimate based on those inputs, not a guarantee that a task will finish on time.
You can also work backward from a target date. If a delivery must arrive by a date in A2 and preparation takes a known number of workdays, use a negative days value to calculate a preparation start date. Confirm whether your organization counts the target day, the starting day, or any handoff day differently; WORKDAY applies its own consistent rule that does not count the start date as the first day moved.
When many rows depend on the same calendar, storing holidays in one maintained range reduces errors. If you add a holiday, formulas that refer to that range recalculate. Keep the list limited to relevant dates and use absolute references when copying formulas, so the holiday range does not shift accidentally.
WORKDAY versus NETWORKDAYS
These functions answer different questions. WORKDAY returns a date a specified number of workdays away from a starting date. NETWORKDAYS counts how many working days fall between two dates, including both endpoint dates when they are working days. Use WORKDAY to calculate a deadline; use NETWORKDAYS to measure elapsed workdays between dates.
For example, with March 4, 2026, in A2 and March 11, 2026, in B2, enter =NETWORKDAYS(A2,B2). It returns 6, counting Wednesday, March 4, through Wednesday, March 11, inclusive, while excluding the weekend. This is different from the five-day forward offset in the earlier WORKDAY example because NETWORKDAYS includes the starting date in its count.
NETWORKDAYS.INTL is the corresponding option when you need a custom weekend pattern. These counting functions do not replace WORKDAY when the desired output is a calculated date.
Common errors and details to check
If a formula returns an unexpected date, first check the input cells. A date entered or imported as text may not be interpreted as a date, and a day count stored as text may not behave as intended. Re-entering the value as a date or number, or correcting the import, is usually better than building a workaround into the formula.
- The result is a number: apply a date number format to the result cell.
- The result is earlier or later than expected: confirm whether the start date should be excluded, check the sign and size of the days argument, and verify the weekend and holiday inputs.
- A holiday appears to be ignored: confirm that the holiday range contains real dates and that the formula points to the correct cells.
- The formula shows an error: check for invalid date values, text arguments, misspelled function names, or mismatched regional list separators. The formulas here use commas, as in standard Excel syntax.
- A copied formula changes its holiday range: use absolute references such as
$F$2:$F$20for a shared list.
WORKDAY returns a date without a time component. It is intended for date-based schedules, not for counting business hours or calculating a precise timestamp. Also remember that a formula only reflects the calendar and assumptions supplied to it; Excel will not automatically add a country’s public holidays or know your company’s working calendar.
Frequently Asked Questions
Does WORKDAY count the starting date?
No. It moves by the number of working days after or before the start date. For example, adding one workday to a Monday returns Tuesday, unless Tuesday is listed as a holiday or the weekend pattern makes it a nonworking day.
How do I calculate a date 10 business days from today?
With the starting date in A2, enter =WORKDAY(A2,10). If A2 is Monday, January 5, 2026, the result is Monday, January 19, 2026, with the default weekend and no holidays. Add a holiday range as the third argument when needed.
Can WORKDAY subtract business days?
Yes. Use a negative number for days. With the date in A2 and the desired number of days to move back in B2, enter =WORKDAY(A2,-B2). Include the holiday range if closures should also be skipped.
Does WORKDAY automatically exclude public holidays?
No. Supply a range of holiday dates as the third argument, or the fourth argument in WORKDAY.INTL. The function excludes only the weekend pattern and dates you provide.
Why does WORKDAY return a number instead of a date?
Excel stores dates as serial numbers. The calculation may be correct even when the cell uses a General or Number format. Select the result cell and apply a date format from Home > Number Format.
When should I use WORKDAY.INTL?
Use it when the nonworking days differ from Saturday and Sunday, or when you need to specify a custom weekend pattern. For the standard Monday-to-Friday workweek, WORKDAY is simpler.
Related
- Supply List Excel Template: How to Build and Use One
- Excel Superscript Shortcut: Apply Superscript to Text
- Subscript vs Superscript in Excel: What’s the Difference?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Volume of a Right Cylinder: Formula, Steps and ExamplesThe volume of a right cylinder is V = πr²h: multiply pi by the radius squared, then by…
- Excel FLOOR Function: How to Round Decimal Values DownTo round a decimal down in Excel, use FLOOR.MATH with the increment you want. With a value of…
- Excel Calendar Quarter Formula: How to Extract Q1-Q4The simplest Excel formula to get the calendar quarter from a date in cell A1 is =ROUNDUP(MONTH(A1)/3,0). This…
- HLOOKUP Match in Excel: Exact and Approximate ResultsTo match a value across the top row of a range in Excel, use HLOOKUP and set its…
- COUNTIF Function to Find Duplicates in Excel: A GuideYes. In Excel, COUNTIF can find duplicates by counting how often each value appears: with values in A2:A7,…
- Excel Date Filter Multiple Criteria: Practical MethodsTo filter dates in Excel by multiple criteria, turn on AutoFilter, open the date column’s dropdown, and choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.