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

hi,
try this:
=today() will display the current date
Saved the normal way, it will remain a formula
when you want to "freeze" the date run this macro:
Sub SaveSpecial
Range("A3").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.Save
end sub
The above macro assumes that you have put =today() in cell
A3 prior to running the macro.
-----Original Message-----
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
.

Hi Aradon,

To do this manually, the Control and semicolon key combination inserts the
current date.

For a VBA solution, try:

Range("A3").Value = Date

---
Regards,
Norman



"Aradon" wrote in message
...
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