The WEEKDAY function in Google Sheets helps you identify the day of the week for a given date, returning a number where each value corresponds to a specific day. This function is useful for scheduling, organizing tasks by weekdays, or analyzing patterns in data based on the day. Whether planning events or managing workflows, the WEEKDAY function provides a straightforward way to incorporate day-based logic into your spreadsheets.
Google Sheets WEEKDAY Function
The WEEKDAY function in Google Sheets returns the day of the week as a number for a given date, where Sunday is typically 1, and Saturday is 7. It helps users analyze and categorize dates effectively, making it useful for scheduling, reporting, or data analysis tasks.
How it Works
The function calculates the day of the week for a specific date and returns a corresponding numeric value. You can customize the start day of the week using optional parameters.
WEEKDAY Function Syntax and Parameters
=WEEKDAY(date, [type])where,
- date: The date you want to evaluate (must be a valid date format).
- type (optional): Determines the numbering system for days of the week.
- 1 (default): Numbers start from Sunday = 1 to Saturday = 7.
- 2: Numbers start from Monday = 1 to Sunday = 7.
- 3: Numbers start from Monday = 0 to Sunday = 6.
This function is ideal for building date-based workflows, automating day-specific tasks, or analyzing weekly trends in data.
How to use WEEKDAY Function with Examples
To use the WEEKDAY function in Google Sheets follow the steps given below:
Step 1: Prepare Your Data
Enter a range of dates in column A. For Example, A2:A6 contains dates like 2024-01-01, 2024-01-02, etc.
Step 2: Select the Cell for the Result
Click on the cell where you want the weekday value to appear, such as B2.
Step 3: Enter the WEEKDAY Formula
Type the formula in the selected cell:
=WEEKDAY(A2)- A2: Refers to the cell containing the date for which you want to find the weekday.
Step 4: Press Enter
Press Enter to see the weekday number corresponding to the date.