View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
hvygns15 hvygns15 is offline
external usenet poster
 
Posts: 2
Default automatic "date update"

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.

"FSt1" wrote:

hi
enter it as a formula.
=today() 'date only
or
=now() 'date+time

regards
FSt1

"hvygns15" wrote:

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.