i have a column of dates (mm,dd,yyyy) how do i count how many are in each
month....

i tried this:

=SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="01"))
=SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="02"))
=SUMPRODUCT(--(TEXT($A$9:$A$272,"mm")="03"))
..............etc

but it spit out zero for oct, nov, dec when it shouldn't have....

thanks

jeremy


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200508/1