WEEKDAY

The WEEKDAY function returns a number representing the day of the week for a given date.

Syntax

=WEEKDAY(serial_number, [return_type])

Parameters

• serial_number: The date for which you want to find the day of the week
• return_type: Optional. A number that determines the type of return value:
  • 1 (default): Numbers 1 (Sunday) through 7 (Saturday)
  • 2: Numbers 1 (Monday) through 7 (Sunday)
  • 3: Numbers 0 (Monday) through 6 (Sunday)

Examples

=WEEKDAY("2025-04-21") // Returns 2 (Monday with default return_type)
=WEEKDAY("2025-04-21", 2) // Returns 1 (Monday when return_type is 2)
=WEEKDAY(TODAY()) // Returns the weekday number for current date