Microsoft Office Forums finding due date of a loan
 Register FAQ Search Today's Posts Mark Forums Read

#1
08-21-2014, 11:14 AM
 paulys Windows 7 32bit Office 2007 Novice Join Date: Aug 2012 Location: Nayarambalam, Kochi, India Posts: 11
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
08-22-2014, 12:35 AM
 bobsone1 Windows Vista Office 2007 Novice Join Date: Jul 2014 Posts: 23

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
08-22-2014, 09:55 AM
 paulys Windows 7 32bit Office 2007 Novice Join Date: Aug 2012 Location: Nayarambalam, Kochi, India Posts: 11

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

Thanks a lot. Regards and prayers.... Pauly Sebastian
#4
08-23-2014, 02:15 AM
 bobsone1 Windows Vista Office 2007 Novice Join Date: Jul 2014 Posts: 23

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.
Attached Files
 Edate test.xlsx (10.5 KB, 7 views)
#5
09-20-2014, 09:31 AM
 paulys Windows 7 32bit Office 2007 Novice Join Date: Aug 2012 Location: Nayarambalam, Kochi, India Posts: 11

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

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post angie450 Excel Programming 2 08-19-2014 08:50 AM MelHerndon Word VBA 3 01-21-2013 04:23 PM gsrikanth Excel 0 05-14-2012 03:25 AM Eddie Excel 1 04-25-2012 08:42 PM PRADEEPB270 Excel 1 01-07-2012 04:45 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:53 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top