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
“dddd” - will result in display full day name.
“ddd” - will result in day name in Short form e.g. Monday as Mon
As you can see we got the day name in the new cell
Use the function
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.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.