Formula to calculate end date of a loan and number of payments left (based on billing day)

[Pulamea]

Good day everyone,

I've exhausted Google searches but couldn't find a complete answer, only a partial one.

I have a table where I have the date the loan was made, the billing date and the number of monthly payments for that loan.

What I'm trying to do is find the end date of the loan based on the number of payments left (based on their billing day) and find the number of payments left (again, based on the billing day).

Does anyone have any idea how to approach this?

Thanks.

 

[Tetra201]

Maybe

=EDATE(EOMONTH(A2,0)+D2,C2)

 

[Pulamea]

Maybe

=EDATE(EOMONTH(A2,0)+D2,C2)

Tetra, I think that's it. For some reason it added 2 more months to every line but I managed to make it calculate the correct date by appending a '-2' at the end of the formula.

Thank you very much for your help.

Really clean and simple

 

[Tetra201]

Glad to have helped.