Do you have a date in your spreadsheet that you want to turn into the day of the week? If so, Microsoft Excel has multiple features and functions to help you do that. We’ll show you how to use them.
To find the day of the week from a date, you have basically three ways. The first method is to turn your date into the day of the week in a numerical form. In this method, Sunday is displayed as number 1, Monday is number 2, and so on. This is calculated with Excel’s WEEKDAY function.
The second method displays the actual name of the day of week, like Sunday, Monday, and so on. This method uses Excel’s
TEXT function that converts your date to the day format.
The third method re-formats your actual dates and displays them as the names of the day of week, like Sunday, Monday, and so on. If you use this method, you do not need a separate column to display the days, as your existing date is overwritten.
To find the day of the week as a number, use Excel’s
WEEKDAY function as follows. The count starts from Sunday, where it is numbered 1. However, you can make the function count from any chosen day (like Monday), as we’ll explain below.
To start, first, open your spreadsheet with Microsoft Excel. In the spreadsheet, make sure you have at least one date. Then select the cell in which you want to display the day of the week.
In the selected cell, type the following
WEEKDAY function and press Enter. In this function, replace
B2 with the cell where you have your date.
If you’d like to use the date directly in the function, type the following
WEEKDAY function with your date in it and press Enter. Keep double quotes around your date.
And in the selected cell, you will see the day of the week for your date as a number.
To make the function count days so that Monday is number 1, modify the function as follows. The number
2 in the function argument tells it to start counting from Monday.
Here’s how your result now looks like:
To copy the function to other cells, drag downwards from the bottom-right corner of the cell where you typed the function.
To display a date’s day of the week as the day name, like Monday, use Excel’s
TEXT function. In this function, you tell Excel to format your date in the day format. You can choose the shortened day name (like Mon) or full day name (like Monday).
Start by opening your spreadsheet with Microsoft Excel. Then select the cell in which you want to display the day of week.
In the selected cell, type the following
TEXT function and press Enter. In this function, replace
B2 with the cell where your date is.
The selected cell will display the day of the week. If you’d prefer a shortened day name, like “Mon” for Monday, remove one
d from the function argument as follows:
And you now have the shortened day name in your selected cell.
Depending on how you like to style your sheets, you may want to format your dates using periods in Excel.
To convert your dates to days of weeks without using a separate column, use Excel’s custom number format. This displays the day of week by its full or shortened name.
To do so, first, open your spreadsheet with Microsoft Excel. Then select the cells containing dates.
In Excel’s ribbon at the top, click the “Home” tab.
In the “Home” tab, from the “Number” section, select “Number Format” (an arrow icon).
A “Format Cells” window will open. On this window, from the “Category” list on the left, select “Custom.”
On the right, click the “Type” box and enter “dddd” (without quotes) for full day names (like Monday) or “ddd” for shortened day names (like Mon). Then, at the bottom, click “OK.”
Excel will turn your selected dates into days of the week.
And that’s how you know what day it was on a specific date in Microsoft Excel. Very useful!
Did you know you can use Excel to calculate someone’s age, too? It’s equally easy to do that.
- › How to Get the Month or Year From a Date in Microsoft Excel
- › 13 Microsoft Excel Date and Time Functions You Should Know
- › The Google Nest Mini Is Back Down to Just $18 Today
- › Why Faraway Websites Load Just as Fast as Nearby Ones
- › Why Spotify Shuffle is Not Truly Random
- › How to Block Subreddits on Reddit
- › Android Phones Are Now More Secure, Thanks to Rust
- › How Does Your Snap Score Work (and How to Increase It)