Using Now function with IF conditions

**Sameer Verma** · 12-28-2014, 12:51 PM

Dear all,

I just wish to do

in C2
=If(A2<>"",Now(),"")

in D2
=If(B2<>"",Now(),"")

I am able to do this but the only challenge is excel updates the time with system time every time.

any suggestion to keep the time static ?

Thanks and Regards
Sameer Verma.

**FDibbins** · 12-28-2014, 01:01 PM

NOW() does just that - it gives you the current date/time, and it will update every time there is any change to the workbook

What exactly are you trying to do?

**Glenn Kennedy** · 12-28-2014, 01:14 PM

Are you wanting a non-updating date stamp. If so look at the first attachment. A date/time is entered in the corresponding cell in column B when an empty cell in A (e.g. A11) is filled (formula solution, with intentional circular reference. You need to enable iterative calculations from EXCEL OPTIONS / FORMULA. Subsequent changes to A11 make no difference to B11.

If, on the other hand you want the date stamp to update only when a cell value changes, check the second attachment. In it, every time the value in A changes, the date stamp updates (VB code).