Forum Discussion
Using multiple NOW formulas in a spreadsheet
I have four cells on a spreadsheet. A1 and A2, both are formatted as numbers. B1 and B2 are using a conditional formula to add a date/time stamp when a value is changed in A1 or A2. For example, the...
comet64 Hans' recommendation applies if you are seeking to capture the first time a non-zero entry is made. If you need to capture the most recent time the entry was changed to a non-zero number, you would probably need to use VBA code in the Worksheet_Change event handler (~a macro).
The reason either of those techniques is needed is because Excel recalculates formulas many times, including each time a workbook is opened. More info