Getting month number from cell

[sharky12345]

I have the following formula which counts the month number for a range of cells that contain data;

=SUMPRODUCT(1*(MONTH(BPBACKUP!$B$2:$B$10000)=1))

The evaluated cells are formatted like this;

dd/mm/yyyy hh:mm

The formula works fine, except for January where it seems to be counting every blank cell, (as far as I can see).

Can anyone give me an idea of what the issue is?

 

[Fluff]

How about
=SUMPRODUCT((BPBACKUP!$B$2:$B$10000<>"")*(MONTH(BPBACKUP!$B$2:$B$10000)=2))

 

[sharky12345]

Cheers Fluff - that works, but I had to change the "=2" to "=1" and it seems to work fine......thanks so much!

 

[Fluff]

You're welcome & thanks for the feedback