Count the number of time a month and year occur in a column

I am having trouble getting my formula to count the number of times a certain month and year combo occur, such as 01/16 etc in my table. The column I am trying to count if F. Currently trying to work with

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

I have used both as just enter and as arrays with ctrl shift enter.

Also

=COUNTIFS(F2:F204,">="&DATE(2016,1,1),F2:F204,"<"&DATE(2016,2,1))

Both work great, now the next thing.....
Q R S T U V W X Y Z AA
2016 2017 2018 2019 2020 2021 2022 2023 2024 2025
January 15 3 0 0 0 0 0 0 0 0
February 15 6 0 0 0 0 0 0 0 0
March 15 5 1 0 0 0 0 0 0 0
April 17 8 2 0 0 0 0 0 0 0
May 17 7 0 0 0 0 0 0 0 0
June 11 6 4 0 0 0 0 0 0 0
July 6 2 1 0 0 0 0 0 0 0
August 14 9 3 1 0 0 0 0 0 0
September 6 2 1 0 0 0 0 0 0 0
October 17 5 1 0 0 0 0 0 0 0
November 10 6 3 0 0 0 0 0 0 0
December 7 1 0 0 0 0 0 0 0 0


I want to be able to put in the year and month in say cells R17 and R18 respectively, is there a way for me to take this now data and have it return the number in say 1, 3, 6 months from that time point? say January 2016 should return 15, 17, and and 6 or do I need a macro for this? The data is in rows 2-14 above.

You can just put those cell references into the Year and Month arguments of the DATE function.
The month needs to be a NUMBER, 1 for Jan, 2 for Feb etc.

=COUNTIFS(F2:F204,">="&DATE(R17,R18,1),F2:F204,"<"&DATE(R17,R18+1,1))

And you can add to the month value to out 3 months

=COUNTIFS(F2:F204,">="&DATE(R17,R18+3,1),F2:F204,"<"&DATE(R17,R18+4,1))

Note the month in the 2nd date is intentionally set to the month AFTER your target month.