IS THERE A FORMULA FOR AUTODATE?

A

Aradon

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
 
G

Guest

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.
 
N

Norman Jones

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
 
Top