Excel WEEKDAY vs WORKDAY: What Each Function Does in Excel

Formulas & functions · Updated November 19, 2026

Excel’s WEEKDAY function tells you which day of the week a date falls on, as a number; WORKDAY returns a date a specified number of working days before or after another date. Use WEEKDAY to classify or test dates, and WORKDAY to calculate deadlines and schedules that skip weekends and, optionally, holidays.

The core difference

Although the names look similar, the functions answer different questions. WEEKDAY takes a date and returns a weekday number. WORKDAY takes a starting date and a number of working days, then returns the resulting date. One produces a number; the other produces a date.

For example, if A2 contains Monday, November 2, 2026, WEEKDAY can return 1 when configured to number Monday as 1. WORKDAY can return Monday, November 9, 2026, when asked for the date five working days after A2. The first result identifies a day of the week; the second moves through a calendar while skipping nonworking days.

Neither function decides what your organization considers a workday in every circumstance. By default, WORKDAY treats Saturday and Sunday as weekends, but you can provide a holiday list or use WORKDAY.INTL to define a different weekend pattern.

How WEEKDAY numbers dates

WEEKDAY has the form WEEKDAY(serial_number, [return_type]). The serial_number is a valid Excel date, and the optional return_type sets the numbering convention. If you omit it, Excel uses type 1: Sunday is 1, Monday is 2, and Saturday is 7.

With the date November 2, 2026 in A2, this formula returns 1 because the date is a Monday and type 2 starts the week on Monday: =WEEKDAY(A2,2). The same date with type 1 returns 2. That difference matters when formulas compare the result to a number.

Return type Numbering Useful when
1 or omitted Sunday = 1 through Saturday = 7 Your week starts Sunday
2 Monday = 1 through Sunday = 7 You want Monday–Friday to be 1–5
3 Monday = 0 through Sunday = 6 You need Monday–Friday as 0–4
11–17 Numbers 1–7, with the selected day as 1 You need a particular weekday to start the sequence
21 Monday = 1 through Sunday = 7 You want ISO-style weekday numbering

Return type 21 changes the weekday numbering only; it does not return an ISO week number. For week numbers, Excel has separate functions such as ISOWEEKNUM. Also, a result of 1 does not universally mean Monday: it depends on the return_type you chose.

How WORKDAY counts forward and backward

WORKDAY uses the structure WORKDAY(start_date, days, [holidays]). The days argument tells Excel how many workdays to move: a positive number moves forward, a negative number moves backward, and zero returns the start date adjusted according to the function’s date calculation. The optional holidays argument supplies dates to exclude in addition to weekends.

If A2 contains Monday, November 2, 2026, this formula returns Monday, November 9, 2026: =WORKDAY(A2,5). Excel counts Tuesday through Friday as four workdays and the following Monday as the fifth. The start date is not counted as the first day when moving forward by five days.

A negative value is useful for finding a date before a deadline. If A2 contains Monday, November 9, 2026, =WORKDAY(A2,-5) returns Monday, November 2, 2026. If days is zero, the result is the start date; it does not move to the nearest weekday just because the starting date is a weekend.

WORKDAY returns an Excel date serial, so a result may display as a number if the cell is formatted as General. Select the result cell and apply a date format from Home > Number Format to show a readable date. Formatting changes how the value appears, not the underlying calculation.

Including holidays and nonstandard weekends

To exclude holidays, keep actual Excel dates in a range and pass that range as the third argument. For example, suppose A2 contains November 2, 2026, and F2 contains November 5, 2026 as a holiday. This formula returns November 10, because the holiday is skipped as well as Saturday and Sunday: =WORKDAY(A2,5,$F$2:$F$10). The range can include more dates; blank cells are ignored.

Holiday entries need to be real date values, not text that merely looks like a date. A holiday that falls on a Saturday or Sunday has no additional effect under the default weekend rules, because those days are already excluded. If a company observes a substitute day, add the observed date to the holiday range too.

For weekend patterns other than Saturday and Sunday, use WORKDAY.INTL. Its weekend argument can be a code or a seven-character string ordered Monday through Sunday, where 1 marks a nonworking day and 0 marks a working day. For instance, if A2 contains Thursday, November 5, 2026, this formula skips Friday and Saturday and returns Monday, November 9: =WORKDAY.INTL(A2,1,"0000110"). Sunday is treated as a working day in that pattern.

WORKDAY.INTL is useful for schedules with Friday–Saturday weekends, rotating calendar conventions, or other fixed weekly patterns. It does not model rotating shifts that change from week to week; those usually require a more detailed schedule and a different calculation approach.

Choosing the right function for a task

  • Use WEEKDAY to label dates as weekdays, detect Saturdays and Sundays, group records by day of the week, or apply rules such as “only process this on a Monday.”
  • Use WORKDAY to calculate a due date a number of business days after an order, a review date before a deadline, or a planned finish date that skips weekends and listed holidays.
  • Use WORKDAY.INTL when the usual Saturday–Sunday weekend is not right for the schedule.
  • Use NETWORKDAYS or NETWORKDAYS.INTL when you want to count working days between two dates, rather than calculate a date after a given number of working days.

A common mix-up is to expect WEEKDAY to count working days. It only identifies a date’s position in the week; it does not know about holidays or calculate elapsed business days. Conversely, WORKDAY does not tell you whether a date is Monday or Tuesday—it returns the date reached by its counting rules.

Practical formulas and examples

For a weekday/weekend label, suppose A2 contains a valid date. The formula below returns “Weekend” for Saturday or Sunday and “Weekday” for Monday through Friday: =IF(WEEKDAY(A2,2)>5,"Weekend","Weekday"). Type 2 is important here because it makes Saturday 6 and Sunday 7. With the type omitted, the same test would incorrectly classify Sunday as 1.

To create a follow-up date five working days after an order date, put the order date in A2 and, if needed, holiday dates in F2:F10. Use =WORKDAY(A2,5,$F$2:$F$10). If A2 is November 2, 2026 and F2 contains November 5, the result is November 10. Without that holiday entry, the result is November 9.

For the number of workdays between a start and end date, use NETWORKDAYS rather than trying to count WEEKDAY results one at a time. If A2 holds the start date, B2 the end date, and F2:F10 the holiday list, =NETWORKDAYS(A2,B2,$F$2:$F$10) counts working days in the date span, including eligible start and end dates. Read the function’s inclusive counting behavior when defining what “between” means for your particular process.

Common errors and date pitfalls

  • Dates stored as text: A cell may look like a date but be text, especially after importing data. WEEKDAY and WORKDAY need usable date values; convert or re-import the dates if Excel reports an error or gives an unexpected result.
  • Wrong return_type: A formula that tests whether WEEKDAY is greater than 5 assumes Monday-based type 2. Include the type explicitly so the logic stays clear.
  • Misunderstanding the count: WORKDAY does not count the start date as day one when moving a positive number of days. Confirm the desired convention for deadlines and service-level rules.
  • Forgetting observed holidays: A list of official holiday dates may not include a weekday substitute for a holiday that lands on a weekend. Add the dates the schedule actually treats as nonworking.
  • Displaying a serial number: The calculation can be correct even when the cell shows a number. Apply a date number format to the result.

Excel dates are stored as serial values, and workbook date systems can differ. For ordinary calculations within one workbook, Excel handles the date system for you. Be cautious when copying raw date serials between workbooks or systems; use displayed dates or reliable date conversions rather than assuming the serial itself has the same meaning everywhere.

Frequently Asked Questions

Does WEEKDAY tell me whether a date is a workday?
Not by itself. WEEKDAY returns a numbered day of the week. You can use it to test for a Saturday or Sunday, but it does not account for a holiday list. For a schedule that includes holidays or custom weekends, use WORKDAY/WORKDAY.INTL for date calculations or NETWORKDAYS/NETWORKDAYS.INTL for counts.

Does WORKDAY include the starting date?
When moving forward or backward by a nonzero number of days, WORKDAY counts from the next eligible workday in that direction; the start date is not day one. With a days argument of zero, it returns the start date.

Can WORKDAY skip holidays?
Yes. Supply a range of holiday dates as the third argument. The dates must be valid Excel dates, and each date in the range is treated as a nonworking day in addition to the function’s weekend pattern.

How do I make Monday equal 1 in WEEKDAY?
Set the second argument to 2, as in =WEEKDAY(A2,2), with a date in A2. Monday through Sunday then map to 1 through 7. Return type 21 also uses Monday as 1, with ISO-style numbering.

What is the difference between WORKDAY and NETWORKDAYS?
WORKDAY calculates a date a given number of workdays away from a start date. NETWORKDAYS counts working days in a date interval. Both can exclude supplied holidays; their INTL versions let you specify a different weekend pattern.

Can WORKDAY handle a Friday–Saturday weekend?
Yes. Use WORKDAY.INTL and specify the weekend pattern with its weekend argument, or use one of its supported weekend codes. The seven-character string is ordered Monday through Sunday, with 1 for nonworking days and 0 for working days.

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.