How to Get day name from Date in Excel

In this article, we will learn about how to get the day name from Date in Excel.
Every Date has a day name. In Excel, we can find the day name from Date. There are 7 days in a week named Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday.
You can obtain the day name of any date in Excel using any method mentioned below.
There are 3 methods to do so

1. Change Format cell : Select the cell and Use shortcut key Ctrl + 1 to open Format cell dialog box and Select Long Date Format Style as shown below.

152
Click Ok
153

1. If you wish to get the Day name in a new cell. Use the Formula

=TEXT(A1,”dddd”)
OR
=TEXT(A1,”ddd”)

“dddd” - will result in display full day name.
“ddd” - will result in day name in Short form e.g. Monday as Mon
154
OR
155
As you can see we got the day name in the new cell

We will use the Combination of CHOOSE and WEEKDAY function.

Use the function

=CHOOSE(WEEKDAY(A3),”Su”,”Mo”,”Tu”,”We”,”Th”,”Fr”,”Sa”)

156
As you can see here, you can rename the days as per your convenience.

These all three methods work in any version of Excel.

Hope you understood how to get the day name from date in Excel. Explore more articles on Date & Time function here. Please feel free to state your query or feedback for the above article.

Related Articles:

How to Get Month name from Date in Excel

How to Get the Month From Date in Excel

How to Calculate Months Between dates in Excel

How to Get day name from Date in Excel

How to Convert date to text in Excel

How to Calculate Remaining Days of Month in Excel

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel

How to use the SUMIF Function in Excel