Hello,

Thanks for the link. I found that this formula worked:


=IF(A1="","",IF(B1="",NOW(),B1)) along with choosing Tools/Options/Calculation (Preferences/Calculation for Macs) and check the Iteration checkbox.

My only problem is that when you update cell A1 it does not update cell B2 to the current time. Is there a way to fix it so that it updates to the last change in cell A1?