Revised dates in excel

[Guest]

How can I add a date that automatically updates every time it is opened excel
(I can do it in Word, but not in excel

 

[Gord Dibben]

In a cell enter =TODAY()

This will update each day.


Gord Dibben MS Excel MVP

 

[Guest]

=TODAY()
in a cell should update each time it is opened.