What would the cell formula be to make these x-axis labels? I want only to
change the date in the first cell and have the next five dates be one week
later. I presume it is an append (&) but cant figure it out:
Cell D4 Cell E4
Cell G4
= Reported & 9/13/05 =Reported & D4+7 . =Projected & F4+7 etc
The x-axis column labels would look like this:
Reported Reported Reported Projected Projected Projected
13 Sep 05 20 Sep 05 27 Sep 05 4 Oct 05 11 Oct 05 18 Oct 05
Bookmarks