Returns the weekday of a date as a number.



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


  • 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).


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).