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

  • Thread starter Thread starter Nocturnal
  • Start date Start date
N

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.

--
 
right click on mouse
click on format cells
numbers tab
custom
enter dddd in box
this will give you Wednesday
 
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
 
Back
Top