Monthly Installment

[Rami9]

I got a loan from bank with monthly installment 2,125 USD; it is due every 27th day of the month. How can I write a formula in single cell to calculate the total paid amount without needing to a second table?

 

[bosco_yip]

In B7, enter formula :

=(DATEDIF(0+"27/12/2020",B1,"m")+1)*B6

 

[Rami9]

Thanks a lot,
It fixed a whole week of trial and errors