#1
|
|||
|
|||
finding due date of a loan
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 |
#2
|
|||
|
|||
If you have 23-01-2010 in A1 then this should do what you want, my test returned 23.01.2015
=EDATE(A1,60) |
#3
|
|||
|
|||
yes! it is perfect. It works for all the possibilities. It is so simple
Thanks a lot. Regards and prayers.... Pauly Sebastian |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
Thanks a lot for cracking your brains. It works perfectly. God bless you
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
Make table cell active add date count date | MelHerndon | Word VBA | 3 | 01-21-2013 04:23 PM |
finding more the one | gsrikanth | Excel | 0 | 05-14-2012 03:25 AM |
Loan manager | Eddie | Excel | 1 | 04-25-2012 08:42 PM |
How to know the outstanding balance amount of a Loan? | PRADEEPB270 | Excel | 1 | 01-07-2012 04:45 AM |