Every Date has a day name. There are 7 days in a week named Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday. In this article, we will see how to get the day name from the given date in Excel. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- If you want to find the day name you can use the below formula.
TEXT(A1,”dddd”)
Syntax Explanations:
- TEXT – This function helps to convert a number to text in the given format. Read more on the TEXT function.
- A1 – It represents the input values from the worksheet.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Example:
Refer to the below example image.
- Here, we will enter the input dates in Column B.
- Now we are going to find the day name of these input dates.
- Select any cell and type the above-given formula.
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
Conclusion:
Here, we have described the simple formula to get the day name from the date in Excel. I hope you like it. If you are stuck or need some help, comment below, and I will try to help as much as possible.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
Top comments (0)