One play ..

Assume the col of dates is in Sheet1, A1:A100

In Sheet2, put

In A1: =ROWS($A$1:A1)

In B1:
=SUMPRODUCT((Sheet1!$A$1:$A$100<"")*(MONTH(Sheet1 !$A$1:$A$100)=A1))

Select A1:B1, fill down to B12

Col A simply returns the month number (Jan=1, Feb=2, etc)
while col B returns the desired counts for the months

Adapt the ranges to suit ..

For a cleaner look in Sheet2, we could switch off extraneous zeros display
in the sheet via clicking:
Tools Options View tab Uncheck "Zero values" OK
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"murtaza" wrote in message
...
hi there,

i've column with date date
25/06/2005
26/06/2005
05/07/2005

i just want the total counts for the months for egs. june = 2 and july =1
in
this case

regards
murtaza