Need to automatically input date one time

[thegustaffa]

I'm making a spreadsheet that will automatically check out movies from
my library to friends, family, etc. I would like the spreadsheet to
enter the date as soon as I enter a name. Problem is, any formula
continues to update the date after I put in a name. Does anyone know
how to have the date automatically enter without updating?

 

[Frank Kabel]

Hi
Have a look at
http://www.mcgimpsey.com/excel/timestamp.html
for some solutions.