Hi,

Do you mean something like :
=IF(A1=1,TODAY(),"no update")

HTH
Carim