WEEKDAY
Syntax
WEEKDAY(<date>)
Description
Returns an integer between (1-7) corresponding to the day of the week of the date.
Day | Integer |
---|---|
Monday | 1 |
Tuesday | 2 |
Wednesday | 3 |
Thursday | 4 |
Friday | 5 |
Saturday | 6 |
Sunday | 7 |
Examples
Date | WEEKDAY returns |
---|---|
Oct 15, 2002 | 2 |
Oct 16, 2002 | 3 |
Oct 17, 2002 | 4 |
Oct 18, 2002 | 5 |
Oct 18, 2003 | 6 |
Oct 18, 2004 | 1 |
Oct 18, 2030 | 5 |