Help With DATEVALUE

[Dick Frederick]

I am sure this has come up before. I wish to return a date in cell (say) B1
to the datevalue in (say) cell B2. Yes, I can type the date in the formula
using quotes, but what I want to do is reverence (say) cell B1 in the
formula and have it return the datevalue. Can anyone tell me how to effect
this? I don't mind using a workaround, but I would not like to use a macro
unless necessary.

TIA,

Dick Frederick

 

[Guest]

If B2 contains a date just use this formula in B1

=B2

format as date

 

[Dick Frederick]

Thank you. I finally found the function that I needed, the N function which
turns a date into the Excel number for that date. Problem solved.

 

[David Biddulph]

But does the N function actually give a different number in the cell from
what you get with =B2?
Isn't it merely a question of cell format as to whether you see a date or a
number?