On sheet 1 in column B type =month(A2) and copy down
In cell A3 on sheet 2 type =countif(sheet1!A2:A26,7)

Repeat on Sheet 2 changing the month value.