Returns a value indicating the day of the week of the specified date.

Syntax  Copy Code
WEEKDAY( Date date, [Integer type = 1] ) → Integer

Parameters

date

Required. The date to inspect.

type

Optional. A value indicating how to represent the day of the week. If omitted, type is assumed to be 1.

Remarks

Returns the day of the week of the specified date, as a number from 0 through 7. The exact meaning depends on the value of type, as illustrated below:

• If type is 1 (or omitted), Sunday is the first day of the week, with value 1; Saturday has value 7.
• If type is 2, Monday is the first day of the week, with value 1; Sunday has value 7.
• If type is 3, Monday is the first day of the week, with value 0; Sunday has value 6.

If type is not integer, it is automatically truncated.

Example

Formula  Copy Code
=WEEKDAY(TODAY())

See Also

Function Reference
DAY Function
MONTH Function
YEAR Function
NOW Function
TODAY Function