counting dates

  • Thread starter Thread starter jeremy via OfficeKB.com
  • Start date Start date
J

jeremy via OfficeKB.com

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
 
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
 
Back
Top