Date recalculates

[MamaBee]

I need help with a date formula. I am using Excel 2007.
I use the following formula to insert a date ....
=IF(ISNUMBER(C3),+TODAY(),"")
Works fine except I do not want the inserted date to recalculate each
time I reopen the worksheet. Is there any way around this?
TIA
MamaBee

 

[Claus Busch]

Hi MamaBee,

Am Mon, 12 Mar 2012 15:04:15 -0300 schrieb MamaBee:

I need help with a date formula. I am using Excel 2007.
I use the following formula to insert a date ....
=IF(ISNUMBER(C3),+TODAY(),"")
Works fine except I do not want the inserted date to recalculate each
time I reopen the worksheet. Is there any way around this?

TODAY is volatile and will always be recalculated.
Insert the date with VBA or copy the cell with the formula and then
Paste => Paste Special => Paste Values.


Regards
Claus Busch