Track payments that are spread over a number of months.

Hi

I need to tack payments that are spread over a number of months.

In the attached example I would like to show the number of payments that are due in the boxes.

The first payment is 6 months after the enrolment date and the second payment is nine months after the enrolment date.

Thanks in advance for your help.
Arvid Finance.xlsx

Do you mean something like this in N6:

=COUNTIFS($D:$D,">="&N5,$D:$D,"<"&DATE(YEAR(N5),MONTH(N5)+1,1))

and this in N7:

=COUNTIFS($E:$E,">="&N5,$E:$E,"<"&DATE(YEAR(N5),MONTH(N5)+1,1))

then copy both formulae across.

Hope this helps.

Pete

Hi Pete

This solution works perfectly, thank you very much.

Regards

Don.