WEEKDAY function

Description

WEEKDAY(date) returns the weekday number of date. Days are numbered from Monday (=1) to Sunday (=7).

Example

WEEKDAY("07.05.1956") returns 4, this is the 4^th day of the week (=Thursday; when date format is MM.DD.YYYY).

Calculator

Related functions

• List of Date and time functions