# WEEKDAY function in Excel

> WEEKDAY returns the day of the week for a date as a number.

Source: https://spreadsheetpractice.com/functions/weekday · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** WEEKDAY returns the day of the week for a date as a number.
- **Syntax:** `=WEEKDAY(serial_number, [return_type])`
- **Most common use:** `=WEEKDAY(A2)` returns 7 (Saturday is 7 with the default numbering (Sunday = 1))
- **Available in:** Every current version
- **Category:** [Date functions](https://spreadsheetpractice.com/functions/category/date)
- **Returns:** A whole number for the day of the week.
- **Google Sheets:** Works in Google Sheets with return types 1, 2 and 3.

## What it does

WEEKDAY returns the day of the week for a date as a number. By default Sunday is 1 and Saturday is 7, but the return_type argument lets you start the week on Monday, which makes weekend tests simpler. Use it to flag weekend dates, schedule shifts or group sales by day of week.

## Syntax

`=WEEKDAY(serial_number, [return_type])`

| Argument | Required? | What it is |
|---|---|---|
| `serial_number` | Required | The date to check. |
| `return_type` | Optional | How to number the days. 1 or omitted: Sunday = 1 to Saturday = 7. 2: Monday = 1 to Sunday = 7. 3: Monday = 0 to Sunday = 6. Excel 2010 and later also accept 11 to 17 to start the week on another day. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=WEEKDAY(A2)` | 7 | Saturday is 7 with the default numbering (Sunday = 1) |
| D3 | `=WEEKDAY(A3,2)` | 7 | Sunday is 7 when the week starts on Monday |
| D4 | `=IF(WEEKDAY(A4,2)>5,"Weekend","Weekday")` | Weekday | Monday, March 9 is a weekday |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Date | Hours |  | Result |
| 2 | 3/7/2026 | 6 |  | 7 |
| 3 | 3/8/2026 | 5 |  | 7 |
| 4 | 3/9/2026 | 8 |  | Weekday |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Weekend test catches the wrong days | With the default numbering, the weekend is 1 and 7, not 6 and 7. Use return_type 2 so Saturday and Sunday are 6 and 7, then test >5. |
| The result shows as a date in January 1900 | The cell has a date format. Format it as General to see the number. |
| #VALUE! | The date is text. Convert it with DATEVALUE first. |

## Tips

- For the day name, use =TEXT(A2,"dddd") (Monday) or =TEXT(A2,"ddd") (Mon).
- Count weekend dates in a list with =SUMPRODUCT(--(WEEKDAY(A2:A20,2)>5)).

## Related functions

- [TEXT](https://spreadsheetpractice.com/functions/text): TEXT turns a number or date into text in the format you choose, such as "$1,250.00" or "March 2026".
- [NETWORKDAYS](https://spreadsheetpractice.com/functions/networkdays): NETWORKDAYS counts the working days between two dates, Monday to Friday, including both the start and end date.
- [WORKDAY](https://spreadsheetpractice.com/functions/workday): WORKDAY returns the date a given number of working days before or after a start date, skipping weekends and any holidays you list.
- [DAY](https://spreadsheetpractice.com/functions/day): DAY returns the day of the month from a date, as a number from 1 to 31.

## Questions

### How do I check if a date is a weekend in Excel?

Use =WEEKDAY(A2,2)>5. With return type 2, Saturday is 6 and Sunday is 7, so anything above 5 is a weekend.

### Why does WEEKDAY return 1 for Sunday?

That is the default numbering, which starts the week on Sunday. Pass 2 as the second argument to start on Monday instead.

### How do I get the day name instead of a number?

Use TEXT: =TEXT(A2,"dddd") returns the full name, such as Wednesday.

## Practice

A graded WEEKDAY exercise ("Number the shift days") is on [the WEEKDAY page](https://spreadsheetpractice.com/functions/weekday). It is checked instantly, then re-checked on changed data.

Lessons that use WEEKDAY:

- [Lesson 25: Tenure, quarters & weekdays](https://spreadsheetpractice.com/learn/tenure-quarters-weekdays) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
