Dayofweek()

Working with Formulas > Functions Used in Formulas > Date/Time Functions > Dayofweek()

DAYOFWEEK() returns the day of the week (1-7) corresponding to the input date, where 1 is Sunday, 2 is Monday, and so forth. If a null date is specified, the function returns zero.

Function Format

DAYOFWEEK(date) 

Return Value

DAYOFWEEK() returns an integer 

Examples

DAYOFWEEK(DATE("07/04/2007")) = 4 

DAYOFWEEK(DATE(2007, 12, 25)) = 3