iif question

[Guest]

This should be an easy one for you gurus...

I a cell, I have a NOW() function that keeps updating everytime a value
changes.

=IF(F22 = "","",NOW())

Isn't there a way to capture the date/time and "lock it" so that it doesn't
change? I'm keeping track of user input date & time values.

tia,

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/timestamp.html

 

[Guest]

Yep. That's what I was looking for. Thank you!

JMorrell