Forum Discussion

John Depierro's avatar
John Depierro
Copper Contributor
Nov 28, 2019

NOW

Has anyone come up with EXCEL formula that records NOW once and never again, without using VBA code?

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 28, 2019

    John Depierro 

    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.

Resources