SheetFX
≡
<< Go back to all functions

WEEKDAY

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

Function Syntax and Parameters

Syntax: WEEKDAY(date, [type])

Parameters:

  • date: The date for which you want to find the day of the week.
  • type (optional): The numerical or logical value that specifies the starting day of the week. The default value is 1 (Sunday).

Step-by-Step Tutorial

  1. Using WEEKDAY with a specific date:

    • Example: =WEEKDAY("2022-01-01")
    • Result: 7 (assuming Sunday is the first day of the week)

  2. Using WEEKDAY with a cell reference:

    • Example: If cell A1 contains the date 2022-01-01, then =WEEKDAY(A1) will return 7.

Use Cases and Scenarios

  1. Project Management: Determine the day of the week for project milestones.
  2. Scheduling: Calculate the weekday for specific date ranges in event planning.
  3. Financial Analysis: Analyze trends based on the day of the week for stock market data.

Related Functions

  • YEAR: Extract the year from a date.
  • MONTH: Extract the month from a date.
  • DAY: Extract the day from a date.

Related Articles