I get the same results with my formula. The manually input numbers are what I am looking for (see yellow section in new upload file). The numbers in the section, Row 15-59 under Mos Remaining are the correct result. The Mos Remaining number represents the months remaining to amortize a certain number based on the months remaining when compared to the Period Ending date. If the Date From and the Date To are outside the Period Ending date then the number returned should be the difference between Date From and Date To.Hi and welcome to the forum
Not sure about your exact requirement, but I have tried something and slightly modified one of your formula, can you check this:
=IF(E5>=$B$2,0,IF((YEAR(F5)-YEAR($B$2))*12+(MONTH(F5)-MONTH($B$2))<0,0,(YEAR(F5)-YEAR($B$2))*12+MONTH(F5)-MONTH($B$2)))
Regards,
I changed the month end date and the formula works. Thank you very much.try, in row 5:
=IFERROR(MIN(DATEDIF($C$4,G5+1,"M"),DATEDIF(F5,G5+1,"M")),0)
and copy down.
There is one date the 28th Feb 2016, this is not the end of the month so datedif (which counts complete months) gives one complete month less than what you seem to want. Rows 8 and 18.
ThanksI changed the formula to shorten it, see my previous msg.