Automate Date Changes Within Excel Workbook

[Rick Rothstein]

The answer to your question: What dates should August 29, 2013, August 30, 2013 and August 31, 2013 become? is those dates would also become a date 6 months into the future.

You completely missed the point of my question. Six months from August 29, 2013 should be February 29, 2014... six months from August 30, 2013 should be February 30, 2014... six months from August 31, 2013 should be February 31, 2014; however, there are no such dates as February 29, February 30 and February 31 in the year 2014... so I need you to tell me what dates you want them to become... should they all become February 28, 2014 (the last day of the month that is six months hence) or should they "leak" over into the next month and become become March 1, March 2 and March 3 respectively?