Put the counts in another range with

=SUM PRODUCT(--(A1:A100=DATE(2004,3,29))

etc.

You can use a cell with the dates and check against that

=SUM PRODUCT(--(A1:A100=H1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Steve" wrote in message
...
I have a column of data that I want to display showing a
progression based on the number of rows per date.
See below. . . there are 6 rows on 3/29, 3 rows on 3/30,4
rows on 3/31, etc.
I want to count the number of rows for each date, perhaps
define a variable for each date as a graph point and
display it in a graph of some kind. It is the logic of how
to count each date value dynamically that I just don't
know how to do.

Thanx in advance!

3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/29/2004
3/30/2004
3/30/2004
3/30/2004
3/31/2004
3/31/2004
3/31/2004
3/31/2004