I need a formula for Excel 2000 that will display the correct current date in
a cell and updates for each day.

For example on 14/09/2004, in cell A3 this is the date that is shown, but
when i load the document the following day it then displays 15/09/2004,
however i dont want it update the date once the document has already been
saved, say if it is the 20/09/2004 and i need to look at a document from
15/09/2004 i dont want the date on the document to change to 20/09/2004.

Is this possible?

Thanks