Hi friends,

I am trying to find a formula for arriving due dates of loans --

There are 3 cells - A1, B1 and C1

A1 = starting date of loan; B1 = period in months and C1 is the result - due date of loan

Different dates may be entered in A1 and different periods in months will be entered in B1. The result should appear in C1 using a suitable formula. Some of the possible entries and the expected results are narrated below.

If I enter 23-01-2010 in A1 and 60 in B1, the result in C1 should be 23-01-2015
If I enter 31-01-2010 in A1 and 63 in B1, the result in C1 should be 30-04-2015
If I enter 31-01-2010 in A1 and 25 in B1, the result in C1 should be 29-02-2012
If I enter 31-01-2010 in A1 and 37 in B1, the result in C1 should be 28-02-2013
If I enter 29-02-2012 in A1 and 60 in B1, the result in C1 should be 28-02-2017



Hope I have placed my problem clearly. Please assist me

Regards...... Pauly Sebastian