How to count unpaid installments.

Not as self-explanatory as you'd think.

Please select one customer and determine what the answer should be in that column, then tell us how you got that answer and point to the data. Then we can think about turning that into a formula.

Sorry. I am trying to give possible answer.

For customer Jharna Hati, the unpaid installments will be -1. Since She has paid upto 20/11/2007 and her next due is on 20/11/2008.

For customer Vishal Maheshwari, the unpaid installments will be -1. Since he as paid upto 21/03/2009 and his next due is on 21/04/2009. [Though the customer has paid installments in advance.]

For cursomer Ramesh Kumar Tiwari, the unpaid installments will be -15. Since he has paid 25/08/2007 and his next due is on 25/11/2008.

and so on.

I am just counting from DateList sheet.

For Jharna Hati Column D15
For Vishal Maheshwari Column F36
For Ramesh Kumar Tiwari Column H16 TO H30.

In the Next Premium Due column the date which falling within 15 days from today, is being formatted with Red Colour as a intimation to contact the insurer for reminder of payment.

I need this number to inform insurer the exact amount due.

Regards,

I think this is what you need

Please Login or Register  to view this content.

copy down