How to automatically update the date any time the Excel is openned

D

DORI

I have a worksheet with a certain cell dedicated for today's date. Is it
possible to programm that cell so that any time I open the file, it
automatically reflects the today's date?
Thanks,
Dori
 
D

Dave Peterson

You could use:
=today()

If you need date and time, you could use:
=now()
(format it nicely)
 
Top