Return to Excel Formulas List

Get Day Name From a Date – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to get the name of the day from a date in Excel and Google Sheets.

day name from date Main Function

Extract the Day Name From a Date

You may need to extract the day name from a date value in Excel. We can do this with the TEXT Function.

The TEXT function converts values to text in the indicated format. You can choose whether you want to display the day name in a long (e.g. “Wednesday”) or short (e.g. “Mon”) form, or as a one- or two-digit number.

TEXT DDDD

TEXT DDD

In each of these two examples, the formula gives us the day of the week as a text string.

TEXT DD

TEXT D

In each of the last two examples, the formula gives us the day of the month. The output is a number stored as text.

Please note that when using the TEXT function, the original date is lost in the conversion; you only keep the text for the day name or number.

Display the Day Name for a Date

There is another way to display the day name for a date: simply format the cell using a custom date format. Select the date, then go to Format Cells > Custom, and enter one of the above formats (dddd, ddd, dd, or d).

Date Format

Get Day Name From a Date in Google Sheets

These formulas work exactly the same in Google Sheets as in Excel.

day name from date Google Function