Practice free

WEEKDAY function

WEEKDAY returns a number for the day of the week a date falls on, handy for weekend flags or grouping by day. By default Sunday is 1, which surprises many people.

Example

Read it as a sentence: find the day of the week for January 1, 2024, counting Sunday as 1, which gives 2.

Practice this in the app

Syntax

WEEKDAY(serial_number, [return_type])

Arguments in [square brackets] are optional.

serial_number (required)
The date to check.
return_type (optional)
1 or omitted: Sunday=1 to Saturday=7; 2: Monday=1 to Sunday=7; 3: Monday=0 to Sunday=6; other codes shift the start day.

Returns: A number for the day of the week.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=WEEKDAY(DATE(2026,1,9)) 6 Friday, default type
=WEEKDAY(DATE(2026,1,9),2) 5 Type 2
=WEEKDAY(DATE(2026,1,9),3) 4 Type 3
=WEEKDAY(DATE(2026,1,9),11) 5 Type 11
=WEEKDAY(DATE(2026,1,9),17) 6 Type 17
=WEEKDAY(0) 7 Serial 0
=WEEKDAY(DATE(2026,1,9),4) #NUM! Invalid type
=WEEKDAY(-1) #NUM! Negative

Watch out for

  • Default numbering starts on Sunday as 1, which surprises many people.
  • Use return_type 2 if you want Monday as 1.
  • Use TEXT(date,"dddd") for the day name.

Where it works

Excel
WEEKDAY is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .