View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default =NOW() from changing

I can't remember how I did it before but I add something to the now() formula
to keep the date from changing, can anyone help? If(b2="","",Now()) or some
condition as such once the date is entered it won't change.