Google Sheets WEEKDAY Function: Syntax, Examples & Tips

date:
The date for which you want to determine the day of the week. This can be a date value, a cell reference containing a date, or a formula that returns a date.

type:
An optional parameter that specifies the type of return value. It determines how the days of the week are numbered. If omitted, the default is 1, where Sunday is 1 and Saturday is 7. Other options include 2 (Monday is 1, Sunday is 7) and 3 (Monday is 0, Sunday is 6).

What is a WEEKDAY Function?

The WEEKDAY function in Google Sheets is a useful tool that returns the day of the week corresponding to a date. It can be particularly helpful for scheduling, planning, and analyzing data based on days of the week. The function can return a number representing the day, which can be customized to start the week on different days.

In simpler terms, WEEKDAY allows you to determine which day of the week a specific date falls on, making it easier to organize and interpret your data.

A Practical Example

Imagine you are tracking project deadlines and want to know which day of the week each deadline falls on:

Deadlines Table:

You want to find out the day of the week for each deadline.

WEEKDAY Formula

To achieve this, you would use the WEEKDAY function as follows:

=WEEKDAY(C2, 1)

In this formula:

• C2 is the cell containing the Deadline date.
• The second argument 1 specifies that the week starts on Sunday (1 = Sunday, 2 = Monday, ..., 7 = Saturday).

Result of the Formula

When you apply the WEEKDAY formula to the Deadlines Table, the output would look like this:

In this case, the WEEKDAY function returns:

• 2 for Monday (October 2, 2023)
• 5 for Thursday (October 5, 2023)
• 7 for Saturday (October 7, 2023)

Why Use WEEKDAY?

WEEKDAY is beneficial because it allows you to easily categorize and analyze data based on the day of the week. This can be particularly useful for scheduling tasks, tracking attendance, or analyzing trends in data over specific days. By understanding which days correspond to specific dates, you can make more informed decisions and improve your planning processes.

Key Takeaways:

• WEEKDAY: A Google Sheets function that returns the day of the week for a given date.
• Customizable: You can specify which day to start the week, making it adaptable to your needs.
• Data Analysis: Helps in organizing and interpreting data based on days of the week.
• Common Use Cases: Ideal for project management, attendance tracking, and any scenario where day-based analysis is necessary.

WEEKDAY is an essential function for anyone working with dates in Google Sheets, providing a straightforward way to enhance data organization and analysis.

Happy spreadsheeting!