thanks g 's
-- will give it a try.

dr350x


"Gary''s Student" wrote:

Consider using a Pivot Table. It will produce a nice table that lists each
date uniquely and the number of time the date occurs in your table. For
example:

tades
6/16/2007
6/16/2007
6/16/2007
6/16/2007
6/16/2007
6/16/2007
6/16/2007
6/16/2007
6/16/2007
6/15/2007
6/15/2007
6/15/2007
6/15/2007
6/15/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
6/17/2007
can produce a table like:


Count of tades
tades Total
6/15/2007 5
6/16/2007 9
6/17/2007 22
(blank)
Grand Total 36


see:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student - gsnu200730


"dr350x" wrote:

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