COUNTIF DATE question

[Guest]

Here is my formula:
{=COUNTIF('Closed Concert Bill Group
issue'!$G:$G,">="&DATEVALUE("02/01/04")--COUNTIF('Closed Concert Bill Group
issue'!$G:$G,"<="&DATEVALUE("02/29/04")))}

Here is the data:
2/1/2004
2/29/2004
1/1/2004
2/22/2004
2/14/2004
2/1/2004
3/5/2004

Why am I getting a number back of 4?? It should return 6.

Essentially, what I am looking for is to count all the occurances between
two dates within a month.

Does this make sense? HELP!!!!

 

[Frank Kabel]

Hi
you can't use COUNTIF for this. Try:
=SUMPRODUCT(--(G1:G1000>=DATE(2004,2,1)),--(G1:G1000<=DATE(2004,2,29)))

Note: Sumproduct does not accept ranges like G:G

 

[Domenic]

Hi,

You could use...

=COUNTIF('Closed Concert Bill Group
issue'!$G:$G,">="&DATEVALUE("02/01/04"))-COUNTIF('Closed Concert Bill
Group issue'!$G:$G,">"&DATEVALUE("02/29/04"))

....but I would stick with Frank's formula.

Cheers!

 

[Domenic]

I am in need to count all dates in the column and was trying to avoid a
finite cell ending.... that's why I used the entire row. any other
suggestions?

Then change Frank's formula to...

=SUMPRODUCT(--(G1:G65535>=DATE(2004,2,1)),--(G1:G65535<=DATE(2004,2,29)))

....which will give you all rows except the last one, or you can use the
formula I gave you in my previous post.

 

[Frank Kabel]

Hi
I'm quite sure the following would be sufficient:
=SUMPRODUCT(--(G1:G60000>=DATE(2004,2,1)),--(G1:G60000<=DATE(2004,2,29)
))