WEEKDAY

Returns a day of the week value given a specific date.  Returns a numeric value (0-6) where Sunday is 0 and Saturday is 6.

Syntax

WEEKDAY(date)

Arguments

date	Date value to extract the weekday value. Use the format (year, month, day)

Example

WEEKDAY(DATE(2002,7,4)) returns 2 since July 4, 2002 falls on a Tuesday.