XL 2010 - Calculate number of payments made since a certain date

First post so go gently on me here. UK DATE FORMATS (DD/MM/CCYY).

I have a table which shows an anniversary date and a paid to date. The payments are made on the same day every six months, so if the paid to date shows as 03/05/2019 then following would be 03/11/2019.
I need to find a way to calculate the number of payment dates which have occurred since the anniversary date (including if a payment date falls on the anniversary date) but not including the paid to date itself.

Am I asking for the moon on a stick here? I know I could work this out myself manually, but this is just a sample of more than 100 I will need to complete this on. Any help guys would be really appreciated.

Originally Posted by shg

What are the correct answers for your examples, and if any are not obvious, why?

They are, in order:
2
1
2
2

These are simple ones but I need a formula or logic that will work with longer periods.

Maybe

Formula:

Please Login or Register  to view this content.

Ah this seems to have got it!! Thanks guys!!!