Syntax

WEEKDAY(when)

Arguments

  • when (Date or DateTime)

Return Value

Number: The day of the week as a number (1 to 7; 1 is Sunday) if when contains a recognizable date, or 0 if not.

Examples

WEEKDAY("1/1/2019") : 3

INDEX(LIST("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"), WEEKDAY("1/1/2019")) (Text)): Tue

WEEKDAY(TODAY()) : Today's numeric day of the week.

(TODAY() - WEEKDAY(TODAY())) : Date of Saturday last week.

(TODAY() - WEEKDAY(TODAY()) + 6) : Date of Friday this week.

(TODAY() - WEEKDAY(TODAY()) + 7 + 4) : Date of Wednesday next week.

See Also

EOMONTH(), WEEKNUM(), WORKDAY()

Did this answer your question?