View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sloandog Sloandog is offline
external usenet poster
 
Posts: 2
Default Automaticly change date in Wroksheet

I am trying to get a cell in my excel spreadsheet to
automatically put the current date in it. I.e. Each day
I print it out, the "As of" date it will change. I knoqw
how to get it to take a date already entered into the
spreadshhet by the following, ="As of: "&TEXT
(F5, "ddMMMyy") but I want todays date to be
automatically input. Can anyone give me some hint on
this one? thanks!