How to count the number of cells with dates in one specific month (google sheets)?

Question

Spreadsheets

I have a table with dates (in the format x.xxx.xxxx) in column A. How can I count the number of cells in column A containing, for example, the 10th or 11th month? COUNTIF doesn't help. I tried this: =COUNTIF(A3:A7; "*.10.2018")

Link to the described table (with the right to edit): https://docs.google.com/spreadsheets/d/1bYThQhP3S2...

Answer 1

Two pivot tables will calculate for you
a filter between =DATE(YEAR(TODATE());10;1) and =DATE(YEAR(TODATE());11;1) for October and almost the same for November.
Having experimented, I found how to write the function:
=COUNTIFS(A:B;">="&DATE(YEAR(TODATE());10;1);A:B;"<"&DATE(YEAR(TODATE());11;1 ))
=COUNTIFS(A:B;">="&DATE(YEAR(TODATE());11;1);A:B;"<"&DATE(YEAR(TODATE());12;1))
The function will be work for the current year.