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 |