hi,
i am trying to count the number of times a date repeats. eg:
4/1/07
4/1/07
4/2/07
4/2/07
4/3/07
..
..
..
4/30/07
4/30/07
ect...
for the whole month
data corralates with number of visits per day.

i have created a helper colum B with number 1-31, and used the following
=SUMPRODUCT(--$A$2:$A$1000=$B2),--($A$2:$A$1000<$B$3))
where A is data, B is helper
returns 0 in all. formated to gen number. have tried several diff formats.

have also tried
=COUNT(A2:A1000)-SUMPRODUCT((B2:B2000<")/COUNTIF(B2:B1000,B2:B1000+(B2:B1000="")))

have also tried
=SUMIF(A1:A1000,"<"&DATE(4/1/07),B1:B31-SUMIF(A1:A1000,+<"&DATE(4,1,07),B1:B31)
It initially returned 0 then next time thru returned N/A


i have tried xldynamic.com
i'm sure there is an easirer way to do this. i'm terrible with formulas, but
i'm chugging at it and i think i'm over my head...
thanks in advance
--
dr350x