HOW DO I FORMAT A CELL IN EXCEL TO PICK CURRENT SYSTEM DATE

[Guest]

i am programming an excel worksheet in which i need a cell to me able to
display to me the current system date. That is anytime i access the file, the
cell should be able to pick the current date as at the day i am accessing it.

please help

 

[Guest]

Hi mechi

Write an Auo_Open macro that runs when you open the file. Write the
Date/Time in a cell you want to have it.
Example:

Sub Auto_Open()
Range("A1") = Now()
End Sub

Regards
reklamo

 

[Dave Peterson]

with activesheet.range("A1")
.numberformat = "mm/dd/yyyy"
.value = date
end with

now will include the time.