How to Use the WEEKDAY Function in Google Sheets
=WEEKDAY(date, [type]). By default Sunday is 1 and Saturday is 7. Type 2 makes Monday 1 and Sunday 7.
What WEEKDAY does
WEEKDAY returns a number, not a name. That number is useful for logic: finding weekends, scheduling by day, or grouping by weekday. To show the name instead, see day name from a date.
WEEKDAY syntax
=WEEKDAY(date, [type])
The date can be a cell reference, a function that returns a date such as DATE, or a date serial number. The optional type sets the numbering. The most common values from Google's help page:
| type | Numbering |
|---|---|
1 (default) | Sunday = 1 … Saturday = 7 |
2 | Monday = 1 … Sunday = 7 |
3 | Monday = 0 … Sunday = 6 |
The page also lists types 11 to 17, which start the week on Monday through Sunday. For example, 11 is Monday = 1 and 16 is Saturday = 1.
A step-by-step example
Cell A2 holds Monday, November 2, 2026.
| A | |
|---|---|
| 1 | Date |
| 2 | 11/2/2026 |
Dates in the tables are shown in month/day/year order. The results do not depend on your display format.
=WEEKDAY(A2)
This returns 2. With the default numbering, Sunday is 1, so Monday is 2. Now start the week on Monday:
=WEEKDAY(A2, 2)
This returns 1.
Spot weekends
With type 2, Saturday is 6 and Sunday is 7, so =WEEKDAY(A2, 2) > 5 is TRUE for weekend dates. Wrap it in IF to label them.
Common mistakes
- Passing text. WEEKDAY does not convert date strings. Use a real date.
- Typing the date inside the formula. Google's help page warns that typing a date such as
10/10/2000straight into the formula is read as a division, not a date. Use a cell reference orDATE(). - Expecting a name. WEEKDAY returns only a number.
- Forgetting the default. Without type, Sunday is 1.
Try it yourself
Use the date above (A2). Type your formula into the box, starting with =, then press Check.
Exercise 1: Default numbering
Write a formula that returns the day-of-week number for the date in A2 using the default numbering.
Exercise 2: Monday as 1
Write a formula that returns the day-of-week number for A2, with Monday as 1.
What to learn next
- Day name from a date: show Monday, Tuesday and so on.
- IF: run a test and return one of two results.
- NETWORKDAYS: count working days between two dates.
Syntax and rules in this guide were checked against Google's WEEKDAY help page. See all guides.