WEEKDAY
Date & Time
Returns the day of the week as a number (1-7).
Translations
EnglishWEEKDAY
FrenchJOURSEM
SpanishDIASEM
GermanWOCHENTAG
ItalianGIORNO.SETTIMANA
PortugueseDIASEMANA
DutchWEEKDAG
PolishDZIEŃ.TYG
RussianДЕНЬНЕД
TurkishHAFTANINGÜNÜ
CzechDENVTÝDNU
HungarianHÉTNAPJA
SwedishVECKODAG
DanishUGEDAG
FinnishVIIKONPÄIVÄ
Syntax
WEEKDAY(serial_number, [return_type])Arguments
serial_numberThe datereturn_type1=Sun-Sat(1-7), 2=Mon-Sun(1-7), 3=Mon-Sun(0-6)(optional)
Examples
=WEEKDAY(TODAY())1-7
Today's day of week (1=Sunday)
=WEEKDAY(A1,2)1-7 (Mon=1)
Monday as first day
=TEXT(A1,"dddd")Day name
Use TEXT for day name instead
Tips & Best Practices
- •Default: Sunday=1, Saturday=7
- •Use return_type 2 for Monday=1
- •Combine with IF for business day logic
Common Mistakes
- •Forgetting the second argument (return_type) changes what number represents which day - the default treats Sunday as 1, which surprises anyone expecting Monday to be 1
- •Using WEEKDAY expecting a day name like "Monday" back - it only returns a number, formatting for a name is a separate step
- •Applying WEEKDAY to a cell that's actually text, not a real date value, which returns an error instead of the expected number
Related Functions
DAYReturns the day-of-month number instead of the day of the week.NETWORKDAYSCounts business days between two dates, using weekday logic internally.TEXTCan format a date to show the weekday name directly, like TEXT(A1,"dddd").Frequently Asked Questions
How do I make Monday equal to 1 instead of Sunday?
Use the second argument: WEEKDAY(A1,2) makes Monday 1 and Sunday 7.
How do I get the weekday name instead of a number?
Use TEXT(A1,"dddd") for the full name, like "Tuesday", or TEXT(A1,"ddd") for the abbreviation.
Does WEEKDAY account for holidays?
No, it purely calculates the day of the week based on the calendar - use NETWORKDAYS with a holiday list if you need to exclude holidays.
Need to translate a formula using WEEKDAY?
Use our translator to convert your complete formula