Excel WORKDAY Formula: Does It Exclude Weekends?

Formulas & functions · Updated November 18, 2026

Yes. In Microsoft Excel for Microsoft 365 on Windows, WORKDAY excludes Saturday and Sunday by default when it calculates a date a specified number of working days before or after another date. You can also supply holidays or use WORKDAY.INTL to define a different weekend pattern.

How WORKDAY handles weekdays and weekends

WORKDAY moves forward or backward through dates, counting only working days. With its default settings, Monday through Friday count; Saturday and Sunday do not. The starting date is the point from which Excel begins counting, not usually the first day added to the result. For example, adding one working day to a Friday normally gives the following Monday.

The function is useful for estimating delivery dates, project milestones, payment processing dates, or a deadline that is measured in business days. It returns a date value, not a written explanation or a count of days. The result may appear as a number if the result cell is formatted as General; that number is Excel’s date serial. Apply a date format to display it as a calendar date.

In the basic example below, A2 contains Friday, December 18, 2026, and B2 contains 3. WORKDAY counts Monday the 21st, Tuesday the 22nd, and Wednesday the 23rd, so the result is December 23, 2026.

With the start date in A2 and the number of working days to add in B2, enter:

=WORKDAY(A2,B2)

Use the basic formula for a deadline

The basic form is WORKDAY(start_date, days, [holidays]). The square brackets in that description mean the holidays argument is optional; do not type the brackets into the formula. A positive days value moves forward, while a negative value moves backward. For instance, subtracting five working days finds a date five counted weekdays earlier, skipping weekends along the way.

Excel requires the starting date to be a valid date value. Enter a date in a cell and reference that cell rather than relying on ambiguous text such as 03/04/26, which can be interpreted differently under different regional date settings. The days argument should be a number, commonly a value in another cell, so the calculation can be updated without editing the formula.

WORKDAY is not the same as adding calendar days. If a task starts on Friday and takes three working days, the result is Wednesday, not Monday: Monday, Tuesday, and Wednesday are the three days counted after Friday. This convention is useful for due dates, but it may differ from a company’s rule about whether the start date itself counts. Confirm the counting convention before using the result as an official deadline.

Exclude holidays as well as weekends

Saturday and Sunday are not the only nonworking days in many schedules. Add a range of holiday dates as the third argument to exclude those dates too. Put actual Excel dates in the range, preferably one date per cell, and keep the range easy to update from year to year. The dates need not be in chronological order, but they must be valid dates rather than labels that only look like dates.

For example, A2 contains December 30, 2026, B2 contains 2, and D2 contains January 1, 2027. December 31 is the first working day after the start. January 1 is in the holiday range and is skipped; Monday, January 4 is the second working day. The result is January 4, 2027.

With the start date in A2, the working-day offset in B2, and the holiday date in D2, use:

=WORKDAY(A2,B2,D2:D2)

A holiday range can include more than one date, such as a named range or a block like D2:D20. Blank cells in a holiday range are ignored. If the same date appears more than once, it does not make Excel skip multiple days; a date either matches the day being considered or it does not. Keep the holiday list aligned with the work calendar you actually need, since Excel does not know which public holidays apply to a location or employer.

Set a different weekend with WORKDAY.INTL

Some organizations work on weekends or observe different rest days. WORKDAY.INTL lets you specify the weekend pattern instead of assuming Saturday and Sunday. Its arguments are the start date, number of working days, an optional weekend setting, and an optional holiday range. The weekend setting can be a numeric code or a seven-character string, where the characters represent Monday through Sunday and 1 marks a nonworking day.

For example, numeric code 7 means Friday and Saturday are weekend days. If A2 contains Thursday, November 5, 2026, and B2 contains 3, the counted workdays are Sunday the 8th, Monday the 9th, and Tuesday the 10th. The result is November 10, 2026.

With that start date in A2 and 3 in B2, enter:

=WORKDAY.INTL(A2,B2,7)

For a Monday-to-Friday workweek, the seven-character weekend string is 0000011: Monday through Friday are marked as working days, and Saturday and Sunday are marked as weekends. A custom string is especially useful for schedules with a single weekly rest day or a less common weekend pair. Count the characters carefully and keep them in Monday-to-Sunday order; an incorrect character position changes which days Excel skips.

WORKDAY versus NETWORKDAYS

WORKDAY answers, “What date comes after or before this many working days?” NETWORKDAYS answers a different question: “How many working days are there between these two dates?” NETWORKDAYS counts working days inclusively when either endpoint is itself a working day. Both functions can exclude a holiday range. NETWORKDAYS.INTL offers the same kind of custom-weekend control as WORKDAY.INTL.

For example, if A2 contains Monday, January 4, 2027, and B2 contains Friday, January 8, 2027, there are five weekdays in that inclusive interval. With those dates in A2 and B2, enter:

=NETWORKDAYS(A2,B2)

The result is 5. If the date range includes a weekend, those days do not count under the default pattern. Be clear about whether a start or end date should count in your own calculation: an inclusive working-day count is not automatically equivalent to a duration rule that excludes the first day or includes a particular deadline date.

Check your dates and format the result

When the answer looks wrong, first check that the input cells contain real Excel dates and numbers. A date pasted from another system may be stored as text. Excel may display a date-looking string, but a function can still fail to treat it as a date. Re-enter the value as a date, or convert the source data before relying on the calculation.

  • If the result is a five-digit number, select the result cell and choose Home > Number Format, then choose a date format. The underlying result can be correct even when it is displayed as a serial number.
  • If the result is one day earlier or later than expected, check whether the start date should count under your business rule and confirm the weekend pattern.
  • If a listed holiday is not being skipped, make sure the holiday cell contains a real date with the same date value, rather than text that merely resembles one.
  • If Excel shows an error, inspect the start date, days value, and holiday range for invalid values, and check that the formula refers to the intended cells.

Excel for Microsoft 365 on Windows normally uses commas between formula arguments, as in the examples. Some regional settings use semicolons instead; if Excel rejects a formula with commas, your installation’s list separator may differ. On Mac and Excel for the web, the functions work similarly, but menus and regional settings can vary. You can still use the same function names and logic.

Choose the right function for your schedule

Use WORKDAY when you need a date offset using a standard Saturday-Sunday weekend. Use WORKDAY.INTL when the weekend differs. Use NETWORKDAYS or NETWORKDAYS.INTL when you need a number of working days between two dates rather than the date reached after an offset. These functions are usually clearer and less error-prone than manually adding days and correcting for weekends.

For a repeating shift pattern or a calendar with exceptions beyond weekly weekends and listed holidays, a single WORKDAY calculation may not represent the full policy. You may need a maintained calendar table that identifies each date as working or nonworking, especially when shifts rotate or closures vary by team. In that case, document the schedule and use a method that explicitly refers to the calendar rather than assuming one standard weekday pattern.

Also distinguish a business-day calculation from elapsed time. WORKDAY does not account for hours, time zones, partial workdays, or a cut-off time such as “orders received after 3 p.m. ship the next day.” It advances by date according to the specified working-day rules. If those details affect a real service commitment, they need separate logic or a more detailed calendar.

Frequently Asked Questions

Does Excel WORKDAY automatically skip weekends?
Yes. WORKDAY skips Saturday and Sunday by default. It does not automatically skip public holidays; add a holiday range if those dates should be excluded.

Does WORKDAY count the start date?
Usually the start date is the reference point, and Excel counts working days after it when moving forward. The result can depend on whether the start date is itself a weekend or on a zero-day offset, so check those edge cases against the exact rule you need.

How do I exclude holidays in a WORKDAY formula?
Place holiday dates in cells and pass their range as the third argument. Make sure those cells hold real Excel date values, and include every holiday relevant to the calendar you are calculating.

How can I use a Sunday-to-Thursday workweek?
Use WORKDAY.INTL and specify the weekend pattern. Its seven-character string uses Monday-to-Sunday order, with 1 for a weekend day and 0 for a working day. For a Sunday-to-Thursday workweek, mark Friday and Saturday as weekend days.

Why does WORKDAY show a number instead of a date?
Excel stores dates as serial numbers. Format the result cell as a date using Home > Number Format; this changes how the value appears, not the calculation.

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.