counting dates

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

One way.........in cell B9 put
=MONTH(A9), and copy down.........
in E1:E12 put 1 through 12.......

then highlight column B and do Tools > DataAnalysis > Histograms.........and
follow menus setting Bin as E1:F12

Vaya con Dios,
Chuck, CABGx3





"jeremy via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
> 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