Count specific month occurrence between 2 dates

[FeedngFrenzy]

Is there a way to count how many times a specific month occurs between two dates? For instance, if we have semi-yearly reviews every April and October, how would I be able to count how many reviews someone has until retirement. I am using today as a base so the data will change and I don't want to update all the records twice a year if I don't have to and they all will be different. Thanks

Edit: I am using Excel 2013 if that helps

 

[FeedngFrenzy]

Care to provide two rows B and D along with the expected number of "reviews" as of today in F and in G?

B and D are just visuals. B shows the total time with the company in years, months and days. D shows the total time remaining in the same format.

 

[FeedngFrenzy]

Tetra201, good catch on those dollar signs ... and eliminating the IFS. Redundant, yes. And also, good thinking on the "already retired" addendum. Teamwork! * smack *


=(YEAR($D1)-(YEAR($A$1)+1)+(MONTH($A$1)<=4)+(MONTH($D1)>=4))*($D1>=$A$1)


And if a specific review date is known and important:



=(YEAR($D1)-(YEAR($A$1)+1)+($A$1<=[specific_date])+($D1>=[specific_date]))*($D1>=$A$1)

Worked perfectly. Thank you ErikTyler and Tetra201.