Get Day Name From a Date – Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 8, 2023
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.





In each of the previous two examples, the formula gives us the day of the week as a string of text. In each of the next 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

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List