How to Use the WEEKDAY Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: WEEKDAY converts a date into a number for the day of the week. The formula is =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:

typeNumbering
1 (default)Sunday = 1 … Saturday = 7
2Monday = 1 … Sunday = 7
3Monday = 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
1Date
211/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

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.

Hint: no second argument is needed.

Exercise 2: Monday as 1

Write a formula that returns the day-of-week number for A2, with Monday as 1.

Hint: set the type to 2.

What to learn next

Syntax and rules in this guide were checked against Google's WEEKDAY help page. See all guides.