Add Workdays to a Date in Excel: Formula and Examples

Formulas & functions · Updated November 21, 2026

To add workdays to a date in Excel, use =WORKDAY(A2,B2), where A2 contains the starting date and B2 contains the number of workdays to add. Excel skips Saturday and Sunday; to skip holidays too, include a holiday-date range as the third argument.

How the WORKDAY formula works

WORKDAY counts forward or backward from a start date, excluding weekends and any holidays you specify. Its syntax is WORKDAY(start_date, days, [holidays]). The square brackets in the syntax mean the holidays argument is optional; do not type those brackets into the formula.

For a positive number of days, the starting date is not counted as the first workday. If the start date is a Monday and you add one workday, the result is Tuesday. If you add five workdays, the result is the following Monday. A negative number moves backward, so adding -1 to a Monday returns the previous Friday, assuming there are no holidays.

The days argument should be a whole number. Excel truncates a fractional value rather than treating it as a fraction of a workday, so use an integer such as 3 rather than 3.5. If the number of days is zero, WORKDAY returns the start date.

Set up and enter the formula

Put the starting date and the number of workdays in separate cells, then place the formula in the cell where you want the calculated date. For example, use A2 for the start date, B2 for the day count, and C2 for the result. With the starting date in A2 and the number of workdays in B2, enter =WORKDAY(A2,B2) in C2.

If A2 contains Wednesday, January 8, 2025, and B2 contains 5, the result is Wednesday, January 15, 2025. The counted dates are Thursday, January 9; Friday, January 10; Monday, January 13; Tuesday, January 14; and Wednesday, January 15. Saturday and Sunday are skipped.

To use the formula in Excel for Microsoft 365 on Windows:

  1. Enter a real Excel date in A2 and a whole-number day count in B2.
  2. Select C2, type the formula, and press Enter.
  3. If the result appears as a number, apply a date format from Home > Number. Choose a short date or another format that suits your sheet.
  4. To calculate more rows, copy or fill the formula down. The relative references will adjust for each row.

Excel for Mac uses the same function and formula. Excel for the web also supports WORKDAY; the ribbon layout can differ slightly by platform, but the formula itself is the same.

Exclude holidays from the calculation

WORKDAY does not know which dates are public holidays, company closures, or leave days. Supply those dates in a worksheet range so Excel can skip them as well as weekends. List the holiday dates in D2:D10, for example. With the start date in A2, the day count in B2, and holiday dates in D2:D10, use =WORKDAY(A2,B2,$D$2:$D$10).

Suppose A2 is January 8, 2025, B2 is 5, and January 13, 2025, appears in the holiday list. The result is Thursday, January 16, 2025. Excel counts January 9, 10, 14, 15, and 16, leaving out the weekend and the holiday. The dollar signs make the holiday range absolute, so it stays D2:D10 when you copy the formula down.

Enter holidays as actual Excel dates, not text that merely looks like a date. You can keep the list on another worksheet and refer to it with a sheet name, such as Holidays!$A$2:$A$20. If the sheet name contains spaces, enclose it in apostrophes, as in 'Company Holidays'!$A$2:$A$20. Expand the range when you add new dates, or use an Excel table column so the list is easier to maintain.

Use a different weekend schedule

For schedules that do not use Saturday and Sunday as the weekend, use WORKDAY.INTL. 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 specifies each day separately.

With A2 holding Thursday, January 9, 2025, and B2 holding 5, the formula =WORKDAY.INTL(A2,B2,7) returns Thursday, January 16, 2025. Weekend code 7 means Friday and Saturday are nonworking days; Sunday through Thursday count as workdays. Add the optional holiday range as the fourth argument when you need both a custom weekend and holiday exclusions.

For a custom pattern, the seven characters run from Monday through Sunday. A 1 marks a nonworking day and a 0 marks a working day. For example, with the start date in A2 and the day count in B2, =WORKDAY.INTL(A2,B2,"0000110",$D$2:$D$10) treats Friday and Saturday as weekends and also excludes dates in D2:D10.

Common numeric weekend codes include 1 for Saturday and Sunday, 2 for Sunday and Monday, and 7 for Friday and Saturday. Codes 11 through 17 each mark one nonworking day, from Sunday (11) through Saturday (17). Check that your chosen pattern matches the actual work schedule; an incorrect weekend code can shift every answer.

Practical examples for schedules

The same calculation can help with delivery estimates, response-time targets, project dates, and staff rotas. Store the inputs in cells rather than typing dates and counts directly into a formula. That makes assumptions visible and allows you to update a date or duration without editing the formula.

  • Business-day deadline: If a request arrives on a date in A2 and the service target is a number of workdays in B2, use WORKDAY to calculate the target date. Add the relevant company closure dates as holidays.
  • Backward planning: If a project milestone is in A2 and you need to find a date five workdays earlier, put -5 in B2. With the milestone date in A2 and the negative day count in B2, use =WORKDAY(A2,B2).
  • Different team schedule: For a team that works Sunday through Thursday, use WORKDAY.INTL with weekend code 7. Include a holiday range if its closure calendar differs from the standard weekend pattern.

These formulas calculate calendar dates from a workday count; they do not calculate hours, shifts, or partial workdays. If a deadline depends on a particular cutoff time, time zone, or business-hours rule, the date-only result may need additional logic and clearly defined inputs.

Dates, formatting, and common problems

Excel stores dates as serial numbers and applies date formatting to display them as readable dates. A result such as 45672 may therefore be a valid date with a General or Number format, not a failed calculation. Select the result and choose a date format from Home > Number. Changing the display format does not change the underlying date.

If the formula returns an unexpected result, check the inputs before changing the formula:

  • The start date is text: Imported dates can look correct but be stored as text. Convert them to real dates, or re-enter them in a date-aware format recognized by your Excel settings.
  • The holiday list is incomplete: Excel skips only dates included in the supplied range. Check that the range covers all relevant closures and that newly added dates are inside it.
  • The start date is a weekend: WORKDAY still applies its workday-counting rules. Decide whether your business process should begin from that date or from the next working date, and confirm the intended rule before relying on the result.
  • The displayed date seems off by one: Remember that the start date is not counted as day one when adding a positive number of workdays. A one-day addition from a working Monday gives Tuesday, not Monday.
  • The formula is shown as text: Make sure the cell is not formatted as Text and that the entry begins with an equals sign. If Excel uses a different regional list separator, it may require semicolons instead of commas; the examples here use commas.

Also check whether the calendar you need treats a holiday that falls on a weekend as an observed weekday closure. WORKDAY excludes only the dates supplied; it does not automatically move weekend holidays to Friday or Monday. Put the observed closure date into the holiday list if that is how the organization operates.

WORKDAY or NETWORKDAYS?

WORKDAY answers the question, “What date is this many workdays before or after a starting date?” NETWORKDAYS answers a different question: “How many workdays are there between two dates?” Both can exclude a holiday list, and NETWORKDAYS.INTL offers custom weekend patterns. Choose the function that matches the value you want to calculate rather than trying to adapt a day-count formula into a date-returning formula.

For example, use WORKDAY when you know a submission date and need to calculate a deadline five workdays later. Use NETWORKDAYS when you already have a start and end date and want to count the working days between them. The treatment of the start and end dates can matter for counting, so check the function’s rules against the way your organization defines a period.

Frequently Asked Questions

How do I add 10 business days to a date in Excel?
Put the date in A2 and 10 in B2. With the starting date in A2 and the number of business days in B2, use =WORKDAY(A2,B2). Add a holiday range if those dates should be excluded too.

How do I add workdays and skip holidays?
List the holiday dates in cells, then provide that range as WORKDAY’s third argument. For a start date in A2, a day count in B2, and holidays in D2:D20, use =WORKDAY(A2,B2,$D$2:$D$20).

Can Excel add workdays backward?
Yes. Use a negative number for the days argument. For example, -3 moves three workdays earlier than the start date, excluding weekends and any holidays in the optional range.

How do I change which days count as the weekend?
Use WORKDAY.INTL and set its weekend argument. For a Friday-Saturday weekend, code 7 works; for a custom pattern, use a seven-character Monday-to-Sunday string with 1 for nonworking days and 0 for working days.

Why does Excel show a number instead of a date?
Excel may be displaying the date’s serial value because the result cell is formatted as General or Number. Apply a date format from Home > Number; the formula result itself does not need to change.

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.