Count if for # for how many cells contain a specific date range

[Bryan]

I have a worksheet with multiple dates in a column. I
want to count how many cells in that column contain dates
for a particular month. Right now I am using countif with
this formula ">12/31/2003 and <02/01/2004" to try to get
Jan 04. I know that I have 18 cells with Jan 04 dates,
but the formula is returning 1. Please advise.

 

[Frank Kabel]

Hi
try something like
=SUMPRODUCT(--(YEAR(A1:A100)=2003),--(MONTH(A1:A100)=12))

 

[Guest]

What goes in the (--( areas

-----Original Message-----
Hi
try something like
=SUMPRODUCT(--(YEAR(A1:A100)=2003),--(MONTH(A1:A100)=12))

.

 

[Peo Sjoblom]

Try


=COUNTIF(Range,">"&DATE(2003,12,31)-COUNTIF(Range,">"&DATE(2004,01,31)

 

[Dave R.]

Leave those in there! That's not an abbreviation or shorthand or anything.

 

[Frank Kabel]

Hi
just leave thos double minus (unaray operator). It coerces the boolean
values to numbers