Formulas > =WEEKDAY()
How To Use WEEKDAY() Function in Google Sheets
Description
How To Actually Use WEEKDAY() in Sheets
WEEKDAY(date, [type])
Try WEEKDAY yourself
In cell B1, use the WEEKDAY formula to determine the day of the week for the date in cell A1. The result should return a number from 1 (Sunday) to 7 (Saturday).
Hints (2)
-
Remember to reference the correct cell for the date.
-
The WEEKDAY function can take an optional second argument for different numbering systems.
1 Better Sheets Tutorial
Building a Year Progress Clone
Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.
EOMONTH()
HOUR()
MONTH()
NOW()
SPARKLINE()
+3 more
Learn more about the WEEKDAY() formula:
Generate a WEEKDAY() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses WEEKDAY(). 2 free AI generations, no signup. Members get unlimited use.
Generate a WEEKDAY() formula