Time array question

Hi Imi_Jay 

Please check whether the following solution is helpful:

Formula in cell F2 is: =COUNTIFS($B$2:$B$28,"<="&EOMONTH(E2,0),$C$2:$C$28,">="&E2)

NOTE

1. Values in range E2:E14 are dates: 1-Jan-2021, 1-Feb-2021,1-Mar-2021 . . . 1-1-2022.

I applied Custom Formatting to make these dates appear as mmm-yyyy.

2. In the above suggested formula, please change cell reference/ranges to suit Your requirement.
3. Please drag the formula down to more rows.

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please Like My answer and mark it as the Best Response.

Thank You!