WEEKDAY

See also A-Z Spreadsheet Function List

Description Returns the day of the week that corresponds to the supplied date.

Syntax WEEKDAY(serial_number)

serial_number is the date as a serial number or as text (e.g., “06-21-94” or “21-Jun-94”).

Remarks WEEKDAY returns a number ranging from 1 (Sunday) to 7 (Saturday).

See Also DAY , NOW , TEXT , and TODAY functions

Examples WEEKDAY(34399.92) returns 1, indicating Sunday

         WEEKDAY(“06/21/94”) returns 3, indicating Tuesday