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