finding due date of a loan

[paulys]

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

[bobsone1]

If you have 23-01-2010 in A1 then this should do what you want, my test returned 23.01.2015

=EDATE(A1,60)

[paulys]

yes! it is perfect. It works for all the possibilities. It is so simple

Thanks a lot. Regards and prayers.... Pauly Sebastian

[bobsone1]

This has bugged me for a couple of days...
I think the formula could be improved to include a cell for entering the duration (months).

I have attached an example of what I think, this solution makes it easier to have different loan durations.

Regards.

P.s. oops, I forgot to add that our excel is a German version so we use semicolons (;) instead of commas (,) in our formula, you might need to change that.

[paulys]

Thanks a lot for cracking your brains. It works perfectly. God bless you