<< Click to Display Table of Contents >> WEEKDAY (weekday) |
Syntax:
WEEKDAY(Date [, Mode])
Description:
Returns the day of the week of a date as a number (from 1 to 7 or from 0 to 6).
Mode (optional) lets you change the type of values to be returned:
1 or omitted: Numbers from 1 (Sunday) to 7 (Saturday) are returned.
2: Numbers from 1 (Monday) to 7 (Sunday) are returned.
3: Numbers from 0 (Monday) to 6 (Sunday) are returned.
Example:
WEEKDAY("09/25/1966") returns 1 (i.e., Sunday)
WEEKDAY("09/25/1966", 2) returns 7 (i.e., Sunday)
See also: