hi
provided that the dates are dates with no times attached, you could use the
countif function.
with a date you want to count in A1 and all dates to count in column
A.........
=countif(A1:A25, A1)
or you could put your count date in a cell off to the side and change the
date in that cell to change the formula results.

Regards
FSt1


"afdmello" wrote:

I have dates in a column

for eg 30-aug-09 ten times
1-sep-09 5 times
3-sep-09 6 times

I want to add or count all dates of 30-aug-09 as 1
all 1-sep-09 as 2 and so on...
my goal being I want to count number of dates

pls help

afd