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

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.