formula IF returning current date

[diane]

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

cheers

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

 

[Arvi Laanemets]

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).