WEEKDAY(serial_number)

Returns the day of the week corresponding to a date represented by an Excel 1900 date system serial number. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday).

See also:

DATE

DAY

MONTH

WEEKNUM

YEAR