Countif function

[Pascale]

I am trying to count the number of records between dates. I have trie
=countif(x:x, month(a2)), where x has date formats dd/mm/yyyy. It i
returning 0, and should be returning a value.

Thanks in advanc

 

[Guest]

Hi

Try something like:
=SUMPRODUCT(--(MONTH(A2:A100)=6))

 

[Pascale]

Thanks Andy, function worked a treat!

 

[Pascale]

the function appears to be counting all empty fields as a january date
How do prevent this from happening

 

[Domenic]

*the function appears to be counting all empty fields as a januar
date. How do prevent this from happening? *

Add the year as your second criteria...

=SUMPRODUCT(--(MONTH(A2:A100)=6),--(YEAR(A2:A100)=2004))

Hope this helps