How to / Dates
How to get the day of the week from a date in Excel
Use =TEXT(A2, "dddd") for the name of the day, such as Saturday. For a number from 1 to 7, use WEEKDAY.
The name of the day
| A | B | C | |
|---|---|---|---|
| 1 | Date | ||
| 2 | 2026-03-14 | Saturday | |
| 3 | 2026-03-16 |
In C2: =TEXT(A2, "dddd") → Saturday
How it works
- TEXT shows a date in the format you give it.
"dddd"is the full name of the day."ddd"is the short one.- The result is text, for labels and headings. It cannot be used in date calculations.
Variations
The short name
A B C 1 Date 2 2026-03-14 Sat 3 2026-03-16 In C2:
=TEXT(A2, "ddd")→ SatThe day as a number, Monday = 1
A B C 1 Date 2 2026-03-14 6 3 2026-03-16 In C2:
=WEEKDAY(A2, 2)→ 6Without the 2, the week starts on Sunday and Saturday is 7.
Weekend or weekday?
A B C 1 Date 2 2026-03-14 Weekend 3 2026-03-16 In C2:
=IF(WEEKDAY(A2, 2)>5, "Weekend", "Weekday")→ WeekendThe name of the month
A B C 1 Date 2 2026-03-14 March 3 2026-03-16 In C2:
=TEXT(A2, "mmmm")→ MarchThe date written out
A B C 1 Date 2 2026-03-14 14 March 2026 3 2026-03-16 In C2:
=TEXT(A2, "d mmmm yyyy")→ 14 March 2026
Watch out for
- Keeping it a date. To show the day name and still have a real date in the cell, do not use a formula: format the cell with the custom format
dddd. - Format codes in other languages. The codes follow the language of Excel. In German Excel the day is
"TTTT", and the day names come out in that language.
Doesn't work on your data? Paste your formula into the formula checker with a few rows of your sheet. It points at the part that fails and says why.
Functions used
- TEXT: Formats a number as text using a format code.
- WEEKDAY: The day of the week as a number.
- WEEKNUM: The week number of the year.
- CHOOSE: Picks a value from a list by its position.
- IF: Returns one value if a condition is TRUE and another if it is FALSE.