View Single Post
  #1   Report Post  
Ruslan
 
Posts: n/a
Default Problem with formula IF(C5="", "",NOW())

I use IF(C5="", "",NOW()) to reflect the date of entry but it changes every
time with new day..how to prevent it?
in other words, if i entered smth yesterday in C5 so that for example in c4
it shows 15/02/05 so I want C4 be the same tomorrow as well, not change C4 to
tomorrow's date!