Formula to calculate maturity date

[mrnacar]

Can someone help?

I need a formula to calculate maturity date based on term and first payment date.

Example:

A1 = Term on Months: 24
A2 = First Pymt Date: 1/5/2011
A3 = Maturity Date: 12/5/2012 <------Need formula here.

 

[rosenbe]

Try...

=DATE(YEAR(A2),MONTH(A2) + A1 - 1, DAY(A2))

 

[mrnacar]

It works! Thank you very much.