How to Get the Day Name From a Date in Google Sheets
=TEXT(A2, "dddd") for the full day name such as Monday, or "ddd" for the short name such as Mon. WEEKDAY alone returns only a number.
Why not WEEKDAY?
WEEKDAY returns a number from 1 to 7. Google's help page says that to display the name you should use the TEXT function or change the cell's number format.
The example
Cell A2 holds Monday, November 2, 2026.
| A | |
|---|---|
| 1 | Date |
| 2 | 11/2/2026 |
Dates in the tables are shown in month/day/year order. The results do not depend on your display format.
=TEXT(A2, "dddd")
This returns Monday. Here is why: the code dddd means the full weekday name. Use three letters for the short name:
=TEXT(A2, "ddd")
This returns Mon.
Month names work the same way
"mmmm" gives the full month name and "mmm" the short one. =TEXT(A2, "mmmm") returns November. Both codes come from the same list on Google's TEXT page.
Common mistakes
- Forgetting the quotation marks around the code.
- Using the wrong number of letters.
dddis short,ddddis full. - Pointing at text, not a date. The cell must hold a real date.
- Expecting a number. The result is text, so you cannot do date maths on it.
Try it yourself
Use the date above (A2). Type your formula into the box, starting with =, then press Check.
Exercise 1: Full day name
Write a formula that shows the full day name (such as Monday) for the date in A2.
Exercise 2: Full month name
Write a formula that shows the full month name (such as November) for the date in A2.
What to learn next
- WEEKDAY: turn a date into a day-of-week number.
- TEXT: format numbers and dates as text.
- DATE: build a date from a year, month and day.
- YEAR, MONTH, DAY: pull parts out of a date.
Syntax and rules in this guide were checked against Google's Day name from a date help page. See all guides.