Automate Date Changes Within Excel Workbook

[Danno2cu]

Rick,
In response to your questions:
1) All of the date values within the files are constants that are not the result of a formula.
2) Yes there are formulas used throughout the files. There may be as many as 100 per worksheet and consist mostly of the following:

• =Sum (range:range)
• =LOOKUP(E21,$U$6:$U$83,$V$6:$V$83)
• =(N22+L23)-(M23)

Thanks for your quick reply,

Dan

[Rick Rothstein]

Okay, one more question. It looks like you are simply adding 6 months to each date within the workbook. What dates should August 29, 2013, August 30, 2013 and August 31, 2013 become?