Hi All

Can anyone assist by providing a formula that will count the number of monthly payments remaining in an annuity/loan scenario?

For example if I have an annuity start date of 31 January 2010 with monthly payments due until 31 December 2014, is there a formula that will automatically calculate the number of payments remaining at any specific date?

Any and all assistance will be gratefully received!

Rgs

Mondo