Returns the day of week of a date, an integer between 1 and 7.
Summary: Extract the day of the week from a date; if text, uses current locale to convert to a date.
Syntax: WEEKDAY( DateParam Date [ ; IntegerType = 1 ] )
Returns: Number
Constraints: None
Semantics: Returns the day of the week from a date, as a number from 0 through 7. The exact meaning depends on the value of Type:
Day of Week |
Type=1 Result |
Type=2 Result |
Type=3 Result |
---|---|---|---|
Sunday |
1 |
7 |
6 |
Monday |
2 |
1 |
0 |
Tuesday |
3 |
2 |
1 |
Wednesday |
4 |
3 |
2 |
Thursday |
5 |
4 |
3 |
Friday |
6 |
5 |
4 |
Saturday |
7 |
6 |
5 |
Syntax |
Result |
---|---|
=WEEKDAY(DATEVALUE("6/21/69")) |
7 |
=WEEKDAY(DATE(1900,1,1),1) |
7 |
BDate = "6/21/69" |
7 |