WEEKDAY
Description
WEEKDAY returns the day of the week that corresponds to the supplied date.
Syntax
WEEKDAY ( serial_number )
Parameter |
Description |
serial_number |
The date as a serial number or as text (for example, 06-21-94 or 21-Jun-94). |
Remarks
WEEKDAY returns a number ranging from 1 (Sunday) to 7 (Saturday).
Examples
This function returns 1, indicating Sunday:
WEEKDAY(34399.92)
This function returns 3, indicating Tuesday:
WEEKDAY("06/21/94")
Also, see