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.
A
B
C
D
1
2
2
3
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.
| Formula | Excel shows | Case |
|---|---|---|
=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 .