WEEKDAY

Returns the day of week of a date, an integer between 1 and 7.

Syntax

Summary: Extract the day of the week from a date; if text, uses current locale to convert to a date.
Syntax: WEEKDAY( DateParam Date [ ; IntegerType = 1 ] )
Returns: Number
Constraints: None
Semantics: Returns the day of the week from a date, as a number from 0 through 7. The exact meaning depends on the value of Type:

1. When Type is 1, Sunday is the first day of the week, with value 1; Saturday has value 7.
2. When Type is 2, Monday is the first day of the week, with value 1; Sunday has value 7.
3. When Type is 3, Monday is the first day of the week, with value 0; Sunday has value 6.

 

Examples