Column D contains a large number of rows of dates (in random order).
Column F contains a text status ("open" or "closed").

I would like to create a series of four columns:

01/2005 10 8 2
02/2005 12 9 3
03/2005 11 7 4

wherein:
the first column is the criterion for counting,
the second column is the number of entries for the target month,
the third column is the number of open cases, and
the fourth column is the number of closed cases.