i am attaching new file with more details. Thank you!
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)
i have attached this excel for your understanding
Thank you in advance.