Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2014, 11:14 AM
paulys paulys is offline finding due date of a loan Windows 7 32bit finding due date of a loan Office 2007
Novice
finding due date of a loan
 
Join Date: Aug 2012
Location: Nayarambalam, Kochi, India
Posts: 11
paulys is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-22-2014, 12:35 AM
bobsone1 bobsone1 is offline finding due date of a loan Windows Vista finding due date of a loan Office 2007
Novice
 
Join Date: Jul 2014
Posts: 23
bobsone1 is on a distinguished road
Default

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

=EDATE(A1,60)
Reply With Quote
  #3  
Old 08-22-2014, 09:55 AM
paulys paulys is offline finding due date of a loan Windows 7 32bit finding due date of a loan Office 2007
Novice
finding due date of a loan
 
Join Date: Aug 2012
Location: Nayarambalam, Kochi, India
Posts: 11
paulys is on a distinguished road
Default

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

Thanks a lot. Regards and prayers.... Pauly Sebastian
Reply With Quote
  #4  
Old 08-23-2014, 02:15 AM
bobsone1 bobsone1 is offline finding due date of a loan Windows Vista finding due date of a loan Office 2007
Novice
 
Join Date: Jul 2014
Posts: 23
bobsone1 is on a distinguished road
Default

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
File Type: xlsx Edate test.xlsx (10.5 KB, 13 views)
Reply With Quote
  #5  
Old 09-20-2014, 09:31 AM
paulys paulys is offline finding due date of a loan Windows 7 32bit finding due date of a loan Office 2007
Novice
finding due date of a loan
 
Join Date: Aug 2012
Location: Nayarambalam, Kochi, India
Posts: 11
paulys is on a distinguished road
Default

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

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
finding due date of a loan 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft