If date in this cell is 3/1/06 then in this cell I want Wednesday

[Nocturnal]

Is this possible?

Say I have a worksheet and I have the date in one cell. With that, would I
be able in another cell, have some type of code that says if cell A1 is this
date, to reference the Windows calender or another function, then place the
actual day in this cell.

--

[davesexcel]

right click on mouse
click on format cells
numbers tab
custom
enter dddd in box
this will give you Wednesday

[SteveG]

You could use davesexcel post in conjunction with this to have it returned in another cell.

If your date is in A1 and you want B1 to return the day of the date in A1 then your formula in B1 would be =A1. Then apply the format as davesexcel posted.

Cheers,


Steve