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.