automatic "date update"

  • Thread starter Thread starter hvygns15
  • Start date Start date
H

hvygns15

How can i set up an automatic "date update" in excel? In other words, I would
like excel to update this cell with the current date automatically every day
without me have to open the file or anything.
 
hi
enter it as a formula.
=today() 'date only
or
=now() 'date+time

regards
FSt1
 
Great! Thanks. Will it continually update without me opening it or will I
have to open the page in order for the "auto update" to work? The reason I am
asking is that I am looking to tie an alert to it and will not always be
opening the page.
 
hi
no. sorry. i guess i misunderstood. the sheet must calculate for the formula
to update.

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

Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Excel Formula to update itself automatically. 10
Excel Vba to change displayed year automatically. 14
Save Today() in cell 3
Changing dates automatically with the computer date 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
graphing data based on todays date 2
Independently controlled dates on each worksheet 2

Back
Top