View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Make date change in excel to current date when opening daily?

=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" wrote:

Can someone please tell me how to set a default in excel to make the date
current evey time i open a file.