View Single Post
  #1   Report Post  
Tinker
 
Posts: n/a
Default Automaticaly entering static dates

Hey all,

My boss asked me to come up with a spreadsheet that logs the type of
computer problem we've had and what we did to fix. He also wants each entry
to be dated in automatically, to make things easier. So, I tried using the
NOW() forumla in the following way:

=IF(ISBLANK(A2),"",NOW())

This would immediatly paste the current date if anyone entered in a name
entry. The only problem I ran into was that the NOW() function continually
updates, even after the entry is put in. So all of my data entries end up
looking like the same date.

My question: Is there a way to do this with the date remaining static, like
a stamp almost, when it's entered?

Thanks! I appreciate any help you guys and girls can provide.

-Tinker