Automate Date Changes Within Excel Workbook

[Rick Rothstein]

Rick,

In my original post I neglected to note that I only need to change dates up to and including the current date (2/18/2013).

I need you to answer the question I asked in Message #4... it will tell me how to handle dates that do not have a corresponding day number in month that is 6 months hence.