How to automatically update the date any time the Excel is openned
You could use:
=today()
If you need date and time, you could use:
=now()
(format it nicely)
DORI wrote:
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
--
Dave Peterson
|