Custom X-axis Labels
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
|