formula IF returning current date
 

I have a formula using IF ie if blank leave blank, if not return current date using NOW(). However, this date is changing daily. Is there something I'm missing where I can ask within the formula to return the date of change and retain that date (instead of it changing daily per the system)?

cheers

just referenced the McGimpsey web page suggested by PEO Sjoblom mid January... thanks.

Hi

You can't do this by formula. Inserting a fixed value into cell is changing
workbooks contents, and formulas can't do this by definition.

When you enter the formula
=TODAY()
into any cell, then literally, it's the formula what is in cell - not todays
date.

You have next options:
a) enter the date manually from keyboard;
b) use a shortcut (Ctrl+Shift+,);
c) use a macro (started p.e. from shortcut);
d) use worksheet's Change event (triggered whenever something is changed in
any cell on sheet - you have to check where the change was made, and
depending on check result the date is inserted into cell, or not).

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets



"diane" wrote in message
...

I have a formula using IF ie if blank leave blank, if not return current
date using NOW(). However, this date is changing daily. Is there
something I'm missing where I can ask within the formula to return the
date of change and retain that date (instead of it changing daily per
the system)?

cheers

just referenced the McGimpsey web page suggested by PEO Sjoblom mid
January... thanks.


--
diane