The WEEKDAY function calculates the day of the week for the supplied date_code. Days of the week are numbered sequentially from Sunday (1) through to Saturday (7).
For example, the formula
WEEKDAY(35612)
returns 4, as 2nd July 1997 occurs on a Wednesday. The WEEKDAY function can be useful in conjunction with the TODAY function, for example:
WEEKDAY(TODAY())
returns the current day of the week.
See also: