Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

Five Ways To Find Day Of Week From Date In Excel

Date:2022-2-19 Author:Sandra

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

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

Five Ways To Find Day Of Week From Date In Excel

Now, you can see the date and week.

Five Ways To Find Day Of Week From Date In Excel

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

Now, each date is followed by a corresponding week.

Five Ways To Find Day Of Week From Date In Excel

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

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

Five Ways To Find Day Of Week From Date In Excel

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

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

Use the fill handle to fill the week column.

Five Ways To Find Day Of Week From Date In Excel

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

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *