Date Stamp in MS Excel Spreadsheet

[kenn]

I use a form written in MS XL that has a cell with a date formula of
=TODAY(). Every time I open this blank form (I have one for each
customer with that customers billing information on it) to enter a new
order for that customer, the date is automatically entered. Very
handy. However, after the current job information is entered and I
save that form as "ABC Development-XYZ Property", and then re-open it
3 days later to add something to it, I would like the date in the
date cell to be the date that I used originally, not today's date.
Any way to do that automatically???

 

[JE McGimpsey]

I use a form written in MS XL that has a cell with a date formula of
=TODAY(). Every time I open this blank form (I have one for each
customer with that customers billing information on it) to enter a new
order for that customer, the date is automatically entered. Very
handy. However, after the current job information is entered and I
save that form as "ABC Development-XYZ Property", and then re-open it
3 days later to add something to it, I would like the date in the
date cell to be the date that I used originally, not today's date.
Any way to do that automatically???

See

http://www.mcgimpsey.com/excel/timestamp.html