How to Get the Day of the Week from a Date in Google Sheets
Use =TEXT(A2,"dddd") to turn a date into its weekday name like Monday. For a number instead, use WEEKDAY.
=TEXT(A2,"dddd")
Returns the full weekday name, e.g. Monday. Use "ddd" for the short Mon form.
How it works
TEXT formats a date using a pattern you supply. The pattern dddd produces the full weekday name and ddd the three-letter version. If you need a number to use in calculations or filtering, WEEKDAY returns 1-7; its second argument lets you choose whether the week starts on Sunday or Monday.
Variations
Short weekday name
=TEXT(A2,"ddd")
Gives Mon, Tue, Wed — handy for compact tables.
Weekday as a number (Mon = 1)
=WEEKDAY(A2,2)
The 2 makes Monday=1 through Sunday=7, the usual business ordering.
Flag weekends
=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")
WEEKDAY>5 catches Saturday and Sunday.
Examples
| Scenario | Formula |
|---|---|
| Label each row with its day name | =TEXT(A2,"dddd") |
| Count how many fall on a Friday | =WEEKDAY(A2,2) |
FAQ
How do I get just Mon instead of Monday?
Use the shorter pattern: =TEXT(A2,"ddd").
What does WEEKDAY return?
A number 1-7. With the second argument 2, Monday is 1 and Sunday is 7.
Why do I get a number when I wanted the name?
WEEKDAY returns a number by design. Use TEXT(A2,"dddd") for the name.
Related formulas
- How to Calculate Percentage of a Total in Google Sheets
- How to Combine Two Columns in Google Sheets
- How to Count Cells With Text in Google Sheets
- How to Count Unique Values in Google Sheets
- How to Remove Duplicates in Google Sheets
- How to Remove Extra Spaces in Google Sheets
- How to Split Text Into Columns in Google Sheets
- How to Sum a Column in Google Sheets