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.

date issues. HELP!!!
 

Hi,

Try this

=TEXT(TODAY()-1,"mmm d")&" - "&TEXT(TODAY(),"mmm d")


--
Thanks,
Shane Devenshire


"Braaad" wrote:

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.