CountIfs returning 0

All,

I'm trying to count the number of Mondays in each month of the year as sometimes it is 4 and sometimes it is 5.

In row 1, I have listed the dates for all 52 Mondays in the year.

In Row 3, I have listed the dates for the first day of every month in the year.

Then, I have tried to use the following formula to count the Mondays in each month: =COUNTIFS($B$1:$BA$1,">=b3",$B$1:$BA$1,"<c3")

However, it returns 0.

Does anyone know of a better way to quickly identify the number of Mondays in each month or why my formula is failing?

Please see the attached file for my problem.

Thanks in advance.

Your formula needs to be like this:

=COUNTIFS($B$1:$BA$1,">="&b3,$B$1:$BA$1,"<"&c3)

as you had it, you were trying to compare the literal strings B3 and C3 to those dates, rather than the cell contents.

Hope this helps.

Pete

You will also need to put 01/01/2016 in N3 if you want to copy the formula across to column M.

Hope this helps.

Pete

You guys are awesome, worked like a charm.

Thanks.