Preserving Auto Date
Posted by Rob on April 24, 2001 10:45 PM
I'm trying to set up a simple "Comment Log" which automatically inputs the current date and time into one cell, when a comment is put into an adjacent one. the formula I'm trying to use is "=IF(B2="","",NOW())". It works, but the problem is it re-evaluates NOW() everytime any cell on the worksheet is changed. Is there a simple way to preserve this time so that it gets input once, then stays the same?
Any help would be appreciated, thanks.