WEEKDAY Function in Google Sheets

Find the day of the week for a given date using the WEEKDAY function.

WEEKDAY Function

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

Syntax

WEEKDAY(date, [type])
  • date: The date for which to find the day of the week.
  • type (optional): Specifies the numbering system to use. Defaults to 1 if omitted.

Examples

  1. Basic Usage

To find the day of the week for "2024-08-15":

=WEEKDAY("2024-08-15")
  1. Using a Different Type

To find the day of the week using the European system (where Monday = 1):

=WEEKDAY("2024-08-15", 2)

Notes

  • The function returns a number from 1 to 7.
  • Different types (1, 2, 3) allow for different week numbering systems.
  • TEXT: Formats a number and converts it to text.
  • DATE: Returns a date from given year, month, and day.