Need formula to zero payment amount made if month changed

[MannyLNJ]

I'm still working on my financial spreadsheet. I have a page in the spreadsheet where I have the date a bill was last paid and the amount of the last payment.

Column C=Amount of the bill
Column D=Bill Due Date
Column E=Last date paid
Column G=Amount Paid This Month
Column H=Due Date
Column I=Amount Still Due this month

See attached example

[dilipandey]

Hi Manny,

Saw your attachment but need to know what you are looking for ? which cell should have what and basis what logic ? thanks.


Regards,
DILIPandey
<click on below * if this helps>

[MannyLNJ]

I apologize the headings were messed up on that attachment here is a new one.

In my head the pseudo code I wrote is

IF (Current Month) > (Month in D) then G=0

This would overwrite what I manually entered in Column G

[dilipandey]

Hi Manny,

Open the attached workbook and click on the blue ball there which will run below macro :-

excelforum-fixed bill(1).xlsm

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>