Wierd. After playing around, that formula works for February - December but
isn't for January. Thank you though. I am REALLY close now

"Pete_UK" wrote:

Try this:

=SUM(IF(MONTH(Date_range)=1,1,0))

This is an array formula so you must commit it with
<CTRL<SHIFT<enter at the same time - if you do it correctly, Excel
will wrap curly braces { } around the formula.

Date_range is the range where your dates are, eg A1:A50 - substitute as
appropriate. This looks for dates where MONTH( ) = 1. You can have this
looking at a cell if you wish, so that you can change the value in the
cell for a different month.

Hope this helps.

Pete