I've seen lots of posts regarding determining fiscal quarter based upon a date. I have a need to get the next fiscal quarter end date based upon the current date and the ending month of the fiscal year. For example:
A1=current date
A2=the month that the fiscal year ends

Using today's date 10/18/12 and a fiscal year that ends in May, the formula should give me 11/30/12 which is the next quarter end date based upon a fiscal year that ends in May.

I need the formula to be dynamic so I can input any date for the current date and change the fiscal month end.

Any assistance is greatly appreciated!