Hello,
I am looking for a help with formulas or VBA Macros on payment installment due. Details is mentioned below.
User enter premiums in column A and effective date in column B and first premium received.
Now the issue start from here. Is a user enter number of installments according to that number of installments it should calculate the installments due but remove first payment?
For example: 3 installments it should calculate 3 due payments and 3 due date
Sample file is attached for your understand.
Bookmarks