Shift data forward

[dennispage1949]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I have created a monthly business proforma that begins January 08 and continues for 5 years. The proforma assumed that startup funding would be available on July 1st, 2008, however, that funding has been delayed for 6 months until January 1st, 2009. Is there an easy way to shift the spreadsheet data forward 6 months to to reflect our new realities?

Thank you

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

I have created a monthly business proforma that begins January 08 and
continues for 5 years. The proforma assumed that startup funding would be
available on July 1st, 2008, however, that funding has been delayed for 6
months until January 1st, 2009. Is there an easy way to shift the spreadsheet
data forward 6 months to to reflect our new realities?

Thank you

Did you (hope!) make all dates out of formulas, referenced against the
start date? If so, you're all set.
If not, this is your chance to do so, since there's no way to globally
change the numeric value of static cells.