Calculating interest

[Pickygame]

I am after a formula that charges interest on a balance only when a weekly repayment ends before the month end. The interest charge is 3% of the reducing balance.

So if weekly repayments are made only add the interest to the outstanding balance at the end of the month. The attached spreadsheet lists the repayment dates but i need it to detect the last payment in the month and apply the interest. I can then select any start date to see the repayments and interest charged

Thanks

Andy

[Ace_XL]

In e2

=IF(MONTH(A2)<>MONTH(A3),D2*3%,"")

Copy down as far as needed

[Pickygame]

Thanks

i replaced the "" with 0 as it returns a value error in month 2