WEEKDAY

Returns the weekday of a date as a number.

Syntax

WEEKDAY(date)

• date - the date from which the weekday should be returned - Value type: date

Remarks

• The function returns

  • 1 for Sunday

  • 2 for Monday

  • 3 for Tuesday

  • 4 for Wednesday

  • 5 for Thursday

  • 6 for Friday

  • 7 for Saturday

• To convert the weekday numbers into weekday names, the function LOOKUP can be used (see example below).

Example

Any value which can be converted to a date can be used as parameter for the WEEKDAY function, e.g. simple numbers.

The LOOKUP function can be used to retrieve the names of the weekdays, by using a conversion table (colored in green).