At times, you need to find what day of the week is 23-2-2021. It often happens when your data contains dates, months, and years. Is it Sunday, Monday, Tuesday, etc?
Most of the time, you need to get a day of the week from the date in Excel but you don’t know how to do it. You may need to plan daily activities, reports, or another schedule while considering the dates with days. Here, you will find how to get a day of the week from the date in Excel.
Let’s find it out how it happens:
How to Get Day of Week from Date in Excel with the TEXT Function?
The TEXT function in Excel lets you convert numbers to text while applying formatting to the text.
=TEXT (1234, “$#, ###”)
Here you will get to know how the TEXT function is used to convert the number in this syntax 1234 into the text string $1,234.
As you know dates are serial numbers that’s why the TEXT function can easily convert date values into text strings along with the day of the week from date in Excel.
TEXT Syntax
=TEXT (Value, Format)
Value: This is a required argument used to convert the value into a text string.
Format: This is a required argument that helps you in formatting while converting the value to a text string.
=TEXT (B2, “dddd”)
With the help of the above formula, you can easily convert date values in cell B2 to the day of the week. In this example, according to the given data you can see Friday is the day of the week found from the date 18-9-2020.
How to Use Format Cells Feature to Get a Date to Day of Week?
For this function, you don’t need any formula as it needs you to change the format of the date. In the Formula Bar, you can see the date while selecting the cell as well as the day name replaces the date. In case, you don’t want to skip the date value, paste it somewhere else and change the format in the new column. For this, you need to follow these steps:
- Paste the date values into a new column.
- Now, choose the dates in the new column and open the Format Cells dialog box. To open it, you can:
- Press CTRL + 1 or else right-click the cells you have selected and choose Format Cells from the context menu.
- When the Format Cells box opens up, you will see the Number tab, from this tab, select Custom In the Type bar and then choose the formats given below:
ddd: This format gives the first 3 letters of the day of the week.
dddd: It gives the day of the week in the full name.
- Now, click OK.
- You can see the days of the week from the date in Excel here. Whenever you click on a day, it will clearly display the date in the Formula Bar.
How to Get Day of Week from Date in Excel with Number Format Drop-down Menu?
When your data contains dates, you can simply check the name of the day for a particular date. For this, you can simply find the day of the week by selecting the cell. Next, you need to click on the Number Format Drop-down menu option given in the Home tab.
Here, you will see the Long Date format that shows the date and adds the day of week from the date in the selected cell
You can even apply the shortcut command for this operation as well.
ALT + H + N + Down Arrow
Summary:
In this post, you have come to know multiple methods that let you find the day of the week from the date in Excel. Each method is worthy enough to practice that’s why you must try all of them so that you realize which method is suitable for you.
