In article
<c57d4cbb-6e2f-423d-8a06-28e20efbd595 DeleteThis @d27g2000prf.googlegroups.com>,
kenn DeleteThis @cdiblinds.com wrote:
> 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