Calculate the number of biweekly payments in a pay period based on first payment date, start and end date

[DataWannaBe]

I've read a lot of threads and usually manage to find my answers, but haven't quite managed on this occasion.

I have a period start date in b1
Period end date in b2
The first date of the biweekly occurrence in b3

Based on the payment being fortnightly, I need to calculate how often it will occur in the period starting on b1 including b2 if I first paid it in b3.

Thanks in advance for any help you can provide.

 

[Snakehips]

@DataWannaBe Maybe try like below.

Testing Formula Update.xlsm
	A	B	C	D
1	PPStart	4/27/24		Payments Due
2	PPEnd	5/26/24		2
3	FirstPay	4/17/24
2020

Cell Formulas
Range	Formula
D2	D2	=(QUOTIENT(B2-B3,14)+1)-(QUOTIENT(B1-B3-1,14)+(B3<B1))

HTH

 

[DataWannaBe]

@DataWannaBe Maybe try like below.

Testing Formula Update.xlsm
	A	B	C	D
1	PPStart	4/27/24		Payments Due
2	PPEnd	5/26/24		2
3	FirstPay	4/17/24
2020

Cell Formulas
Range	Formula
D2	D2	=(QUOTIENT(B2-B3,14)+1)-(QUOTIENT(B1-B3-1,14)+(B3<B1))

HTH

Genius! Thank you so much Snakehips and apologies for the ridiculous delay coming back to you, I've been dealing with a family situation, took leave and have been trying to get caught up.
This is basically what I'm looking for, so much simpler than previous things I'd tried.