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

If B2 contains a date just use this formula in B1

=B2

format as date

"Dick Frederick" wrote:

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

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.

"daddylonglegs" wrote in message
...
If B2 contains a date just use this formula in B1

=B2

format as date

"Dick Frederick" wrote:

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

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?
--
David Biddulph

"Dick Frederick" wrote in message
...
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.

"daddylonglegs" wrote in message
...
If B2 contains a date just use this formula in B1

=B2

format as date

"Dick Frederick" wrote:

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