• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

return amount/value under specific cell(month) based on calculation and frequency - VBA or EXCEL


New Member

i need an expert in VBA or Excel help.

i would like to return the amount (this will be coupon payment) to its due month based on start date and end date and frequency of payment.

i want to see when how much coupon payments are collected based on the timeline (monthly)

Please note that the start and end date may differ and i will have hundreds of lines

i have attached this excel for your understanding

Thank you in advance.



New Member
apologies, i am attaching new file with comments.

i really appreciate your help - i've spent days on this without any clue.