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.

Choose Date In the category, then select the type which includes week.

Now, you can see the date and week.

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.

Now, each date is followed by a corresponding week.

No.3 The TEXT Function

Enter =TEXT(A2,”aaa”) in cell B2 and press enter key.

Double-click the black solid cross or use the fill handle.

No.4 The WEEKDAY Function

Enter =WEEKDAY (A2,2) in cell B2 and press Enter key. Then fill this area.

No. 5 The MOD Function

Enter =IF(MOD(A2,7)<2, “Weekend”, “Workday”) in cell B2, and press Enter key.

Use the fill handle to fill the week column.

That’s all about these five ways to find day of week from date in Excel. Hope this can be helpful to you.