using results of a formula in a count if when the results are a date

Hi I have a list of dates in one column and then another column which lists the month this date falls into by name. the month name is created using this formula (date being in column L - there are also some blank cells in column L, I have set the format on the month name cells to custom, type mmmmmm so it brings back the full month name).

=IF(L10=0,"",L10)

I now want to have a formula that counts every date in January and then another one that counts February etc.... If I do a normal countif formula it comes back as 0 as it won't count any of the cells containing a formula. Can anyone help me with this?

Hi the date cells (C1 in your message) are not formatted as MMMMMM they are formatted as date *14/03/2015 will this solution still work?

Hi sorry, my mistake, ignore my previous post. the formula works fine on your attachement but I cannot get it to work on mine! My data and formulas are on different tabs on my spreadsheet so my formula looks like this:

=COUNTIFS('Open Days'!L:L,">="&Summary!D8,'Open Days'!L:L,"<"&EDATE(Summary!D8,1))

open days is the tab with the data and summary is the tab with the criteria and where I want the formula result.TEST.xlsx

Thank you so much that has worked!! schoolboy error on not locking the range, I should have known better than that!