Make date change in excel to current date when opening daily?

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

Guest

Can someone please tell me how to set a default in excel to make the date
current evey time i open a file.
 
=TODAY() typed in any cell will return the current date. If the file is
saved and re-opened tomorrow, it will show tomorrow's date.......

hth
Vaya con Dios,
Chuck, CABGx3
 
jamie said:
Can someone please tell me how to set a default in excel
to make the date current evey time i open a file.
Click to expand...

Use the TODAY() function
Eg: in A1: =TODAY()
A1 will always return the current date
(calc mode assumed set to auto, of course)

---
 
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

How to change default date formula on Excel worksheet 2
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
excel is making binary changes without adjusting date&time 1
Excel How to get the number of days an item was opened from the today's date. 14
change date format 1
Current date 2
Excel Format Problem - Date Overrides Format 5
Macro about date compare 7

Back
Top