How do I convert the date to the corresponding day of the we

[PerfectTommy]

I am sure this has been asked before, but the search function is not working and I am just about blind from searching through the previous pages..... sorry.

I would like to know how to convert the date to the correct day of the week. For example, in column A I have 4/1/02. I would like for column B to show "Monday". Is there a formula (or a button/filter/something) to do this?

Thanks in advance for the assistance.

 

[AJ]

If you use the formula
=DAY(A1)
and then custom format the cell as "dddd"
Should do the trick.

Rgds
AJ

 

[AJ]

Actually that doesn't work does it!

Try copying your cells from column A to Column B and then reformatting them as "dddd" instead.

 

[Mark W.]

On 2002-04-19 07:22, PerfectTommy wrote:
I am sure this has been asked before, but the search function is not working and I am just about blind from searching through the previous pages..... sorry.

I would like to know how to convert the date to the correct day of the week. For example, in column A I have 4/1/02. I would like for column B to show "Monday". Is there a formula (or a button/filter/something) to do this?

Thanks in advance for the assistance.

Use =TEXT(A1,"dddd") in B1

Or...

just enter =A1 in B1 and format as dddd

 

[PerfectTommy]

It works! Simple and effective. Thanks so much.