Bi-weekly pay

[Luigi802]

I'm trying to calculate how many bi-weekly checks total in a given month, how many have past month and how many are remaining. For example I used the formula "=3-(A3-MOD(A3-P$3-1,14)+41 >EOMONTH(A3,0))" to calculate total # of bi-weekly checks in any given month, A3 being the date of month in question, and P3 being the date a a payday, this seems to work fine, but today is the 9th of march and there should be 0 paychecks so far his month and 2 remaining, when the 11th arrives it should read 1 so far and 1 remaining, not sure how to do this?