View Single Post
  #1   Report Post  
PM
 
Posts: n/a
Default Help - Information with time and date

I have a spressheet that automatically populates 2 cells with the current
time and date using the TODAY() and NOW () functions. Unfortunately, when I
go back into the sheet at a later date or time it repopulates the cells with
the new time and date.

e.g. First Visit date set to 5-Jan 05 and time set to 09:20 AM.
Second visit date set to 5-Jan 05 and time set to 09:25 AM.
Third visit date set to 6-Jan 05 and time set to 10:00 AM.

Is there a way that I can only get the cells populated once?

Any help would be appreciated.