View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Braaad Braaad is offline
external usenet poster
 
Posts: 1
Default date issues. HELP!!!

I update the same spreadsheets everyday. The company I work for works 24
hours a day so my spreadsheet are titled with yesterday's date through today.
(ex. Oct 15- Oct 16) I know that if I hit CTRL ; it will automatically fill
that cell with today's date, but can it be setup to display yesterday through
today? Everyday I must go on each sheet and change this area before I press
on. I would love to have it so I could hit a shortcut for this. Thanks.