Moving diminshed to date

SquirrelGuirrel · May 15th, 2002, 12:55 PM

Hi there, here is my question o' the day:
I have a file of "loans" for which the amount owed dimishes each month in an equal amount. So Each loan is divided by 12, and as time passes I want another column to sum the amount diminished to date(doesn't need to be date specific, just month). So if you open the file in april (any day in april) and the loan for $500 was made in February, the diminished amount would be 2 months worth of the monthly amount. Loan for $500 made in Feb, file opened in April, dimished to date would be $125. I am not really concerned with the month name or days as I am the count of months that have passed since loan was made, as loans will be given throught the year. All loans are for $500. Thanks for any help you can provide

Heidi

I searched the old Q&A but didn't find anything. if this has already been aswered for someone else, let me know

Juan Pablo González · May 15th, 2002, 01:22 PM

If your "starting" date is in A3, and your "current" date is in A4, you could try the following formula to "count" the number of months that have passed. You could then use this number to multiply it by your loans amount / 12.

=TEXT(A4,"m")-TEXT(A3,"m")+(TEXT(A4,"m")

SquirrelGuirrel · May 24th, 2002, 05:12 PM

Thank you so much

May 15th, 2002, 01:22 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	If your "starting" date is in A3, and your "current" date is in A4, you could try the following formula to "count" the number of months that have passed. You could then use this number to multiply it by your loans amount / 12. =TEXT(A4,"m")-TEXT(A3,"m")+(TEXT(A4,"m") __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 12:55 PM	#1
SquirrelGuirrel New Member Join Date: Feb 2002 Location: California Posts: 10	Hi there, here is my question o' the day: I have a file of "loans" for which the amount owed dimishes each month in an equal amount. So Each loan is divided by 12, and as time passes I want another column to sum the amount diminished to date(doesn't need to be date specific, just month). So if you open the file in april (any day in april) and the loan for $500 was made in February, the diminished amount would be 2 months worth of the monthly amount. Loan for $500 made in Feb, file opened in April, dimished to date would be $125. I am not really concerned with the month name or days as I am the count of months that have passed since loan was made, as loans will be given throught the year. All loans are for $500. Thanks for any help you can provide Heidi I searched the old Q&A but didn't find anything. if this has already been aswered for someone else, let me know

May 24th, 2002, 05:12 PM	#3
SquirrelGuirrel New Member Join Date: Feb 2002 Location: California Posts: 10	Thank you so much