WEEKDAY(date_code)

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:

Other date functions