View Single Post
  #2   Report Post  
mrscott
 
Posts: n/a
Default

Hi David,

Easy to fix. Simply go to View--Header/Footer--click either Custom
Header or Custom Footer. From there you'll see several icons you can
select. Two of them are for inserting date and time. Select what you
need and viola! Problem solved.

David wrote:
I have a need to automatically save the current date to a cell in an excel spreadsheet every time the sheet is saved.

Today() always returns the current date, so once I open the sheet on a new day I can no longer see the date the information was last updated, i.e. saved.

Any help would be appreciated.