How to Get the Day Name From a Date in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 4 min read · includes 2 free exercises

In short: Use =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
1Date
211/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

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.

Hint: four d letters.

Exercise 2: Full month name

Write a formula that shows the full month name (such as November) for the date in A2.

Hint: four m letters.

What to learn next

Syntax and rules in this guide were checked against Google's Day name from a date help page. See all guides.