The WEEKDAY function
The day of the week of a date, as a number. By default, the week starts on Sunday: worth knowing.
Syntax
=WEEKDAY(serial_number, [return_type])
In a French Excel: =JOURSEM(numéro_de_série; [type_retour]).
Arguments
- serial_number: the date.
- return_type: 1 (default) Sunday = 1; 2 Monday = 1 and Sunday = 7.
An example
=WEEKDAY(A2,2)>5
TRUE for a Saturday or a Sunday.
Pitfalls
- Without a second argument, Monday is 2 and Sunday 1.
- A date stored as text: #VALUE!.
Going further
Frequently asked questions
- How do I get the day name?
=TEXT(A2,"dddd")returns "Monday" in an English Excel.