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

To get the day of the week from a date in Google Sheets, use TEXT with the format "dddd". With a date in A2:

=TEXT(A2, "dddd")

For Monday, November 9, 2026, this returns Monday. Use "ddd" for the short name, Mon. The rest of this guide covers showing the day next to the date without a formula, flagging weekends, filling a whole column and the blank-cell problem.

Tested in Google Sheets. On November 9, 2026 we entered the formulas on this page in Google Sheets, in spreadsheets set to the United States and to Spain, including empty cells, and compared the results with values calculated independently. How we test

Full or short day name

Formula Result for 11/9/2026
=TEXT(A2, "dddd") Monday
=TEXT(A2, "ddd") Mon
=TEXT(A2, "dddd, mmmm d") Monday, November 9

TEXT returns text, so the result can’t be used in date calculations. Keep the original date in its own column and use the day name only for display or grouping.

Show the day without a formula

If you want the date cell itself to display the day, change its number format instead of adding a column. Select the cells, choose Format → Number → Custom date and time and add the day of the week to the format. The cell still holds the same date, so formulas that use it keep working.

The day as a number: WEEKDAY

When you need to calculate with the day of the week, WEEKDAY returns a number instead of a name. By default, Sunday is 1 and Saturday is 7. With the second argument set to 2, the week starts on Monday:

=WEEKDAY(A2, 2)

For 11/9/2026 this returns 1 (Monday), and Sunday returns 7. That makes it easy to flag weekends:

=IF(WEEKDAY(A2, 2) > 5, "Weekend", "Weekday")

To color weekend dates instead of labeling them, use the same test in a conditional formatting rule. Our conditional formatting examples include a weekend rule that also skips blank cells.

Custom labels with CHOOSE

To show your own labels, for example shift names or abbreviations in a fixed language, combine WEEKDAY with CHOOSE:

=CHOOSE(WEEKDAY(A2, 2), "Mo", "Tu", "We", "Th", "Fr", "Sa", "Su")

Fill a whole column

With dates in A2:A, this formula in B2 fills the column and leaves rows without a date empty:

=ARRAYFORMULA(IF(A2:A = "", "", TEXT(A2:A, "dddd")))

Day names in other languages

TEXT writes the day name in the language of the spreadsheet’s locale, set in File → Settings. In a spreadsheet set to Spain, the same formula returns lunes instead of Monday. To always get English names regardless of the locale, use the CHOOSE formula above.

When the day name looks wrong

An empty cell returns “Saturday”

A blank cell counts as 0, and day 0 in Google Sheets is Saturday, December 30, 1899. We checked it: =TEXT(A2, "dddd") on an empty A2 returned Saturday. Wrap the formula in IF, as in the column example above: =IF(A2 = "", "", TEXT(A2, "dddd")).

The result is the date itself, not a day name

The cell holds text that looks like a date, not a real date, so TEXT has nothing to format and returns the text unchanged. Text dates are usually aligned to the left. Re-enter the date in your spreadsheet’s date format, or see why dates in dd/mm/yyyy don’t work as dates.

The day is off by one

If WEEKDAY seems wrong, check the second argument. Without it, 1 means Sunday; with 2, 1 means Monday.

Related guides