index Match to reformat data

Stanley one thing I forgot to include in my example, is after the month info, I have columns that combine the total, as shown in the example worksheet.

Is there a way to eliminate it from going past the dates?
So if it is March it would go to 3/31/2011, and if it is April it would go to 4/30/2011

I highlighted the areas in the Final Format worksheet to show you.


Thanks for your help, if needs be, I can work around this issue.