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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I copied Visible Cells Only, but it pastes only the first cell 1
Can't change the cell back to blank when there is a date in it. 0
Help with date formula and colour change 3
CONDITIONAL FORMATTING QUERY 0
Constant date in one cell 1
hlookup with the sheet name is a reference from another cell 2
Excel VBA 1
Conditional formating 4

Back
Top