Time stamping

[SidBord]

You can't have your cake and eat it too. If you freeze the
date, then how can it be updated the next time?
What you need to do is figure out a scheme to move the
current time stamp value to another location before you
update it. You could have two locations: one labeled
"current time" and the other labeled "last time opened".
Your're gonna need to write a macro to do this. I don't
think you can do it with just formulas.

-----Original Message-----
When working in Excel is it possible to do either of the following things:

1) Have a template update date and time every time you

open it, but then freeze that date and time upon saving?
When I use NOW() it does not freeze the time after it is saved.

2) Is there a formula that will caculate/track every time

you open the same document (such as automatically
increasing the last invoice number by 1)?