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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You could use:
=today()

If you need date and time, you could use:
=now()
(format it nicely)
 
Thank you very much Dave.
Dori

Dave Peterson said:
You could use:
=today()

If you need date and time, you could use:
=now()
(format it nicely)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically update date 5
Automatically insert date 2
How to show file creation date in a worksheet cell 3
Dates 4
Function to Return a Date Value Q 4
Date Function needed 1
Excel Macro to automatically go to the right of the last colored cell 0
Excel How to get the number of days an item was opened from the today's date. 14

Back
Top