Forum Discussion
Has anyone come up with EXCEL formula that records NOW once and never again, without using VBA code?
John, first you need to enable iterative calculations
(be careful with this option, it could be side effect in another places).
If you'd like to put timestamp in A1 when in B1 will be entered "x", use in A1 formula
=IF(B1="x",IF(A1="",NOW(),A1),"")Something like this. It could be another logic around, but the core is iterative calculations.