If you want to quickly find out what day of the week it is, are you ready to turn on your phone calendar right away? In Excel, there are actually five ways to quickly figure out what day of the week any date is. Let’s get started.
No.1 Format Cells
Select the area of dates and right-click to choose Format Cells in the list.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-13.png)
Choose Date In the category, then select the type which includes week.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-14.png)
Now, you can see the date and week.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-15.png)
No.2 Format Cells
Open the Format Cells window in the same way.
Choose the Custom in the Category. Enter yyyy/m/d aaaa in the type and hit ok.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-16.png)
Now, each date is followed by a corresponding week.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-17.png)
No.3 The TEXT Function
Enter =TEXT(A2,”aaa”) in cell B2 and press enter key.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-18.png)
Double-click the black solid cross or use the fill handle.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-19.png)
No.4 The WEEKDAY Function
Enter =WEEKDAY (A2,2) in cell B2 and press Enter key. Then fill this area.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-20-812x720.png)
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-21-746x720.png)
No. 5 The MOD Function
Enter =IF(MOD(A2,7)<2, “Weekend”, “Workday”) in cell B2, and press Enter key.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-22.png)
Use the fill handle to fill the week column.
![Five Ways To Find Day Of Week From Date In Excel Five Ways To Find Day Of Week From Date In Excel](https://www.myofficetricks.com/wp-content/uploads/2022/02/image-23.png)
That’s all about these five ways to find day of week from date in Excel. Hope this can be helpful to you.
Leave a Reply