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?

[Danno2cu]

Rick,

My apologies for not being more clear in my original post.

I'm looking for a way to convert dates in Excel from a current date to a different yet correspondingly valid "day-of-the-week" date in the future.

In the example I used regarding Calendar vs. Fiscal dates, it was my intention to illustrate that if the Calendar year begins on Sunday, January 1, 2012 and my Fiscal year begins on Sunday July 1, 2012 how do I convert all instances of Sunday, January 1, 2012 to Sunday July 1, 2012.

Unfortunately for purposes of clearly describing my intention, these two months both begin with the first of the month being on a Monday. To be more descriptive, my example should have been something more like: How do I locate all instances of Calendar Date Monday March 5, 2012 and convert it to Fiscal Date Monday June 4, 2012 and then Tuesday March 6, 2012 and convert it to Tuesday June 5, 2012?

Does this help clarify?

Dan

[Rick Rothstein]

To be more descriptive, my example should have been something more like: How do I locate all instances of Calendar Date Monday March 5, 2012 and convert it to Fiscal Date Monday June 4, 2012 and then Tuesday March 6, 2012 and convert it to Tuesday June 5, 2012?

Does this help clarify?

That clears up one misunderstanding I had, but unfortunately raises another. Why is the March dates being advanced to June? My first impression is that all dates would be advance by six months. Then, in re-reading your original message coupled with your last message, I could not decide if the "add 6 months" was a blanket rule for any date or if you wanted all dates advanced to July of that year, but moving from March to June does not fit in with either of those "guesses" by me. Maybe you could post a table with one or two dates from each month of the year and show me the dates they should become... then maybe I will be able to see the underlying logic for your request, but right now, I seem to be completely missing it.