Sorry. I've been unable to get onto this site for a few days. If you put a
Heading in the cell above your data column, you can still use a pivot pretty
quickly.
Just drag Heading into the Row Area and Heading again into the Data Area,
using the Count function as your aggregation.

This will give you something that looks like:
Count of Dates
Dates Total
14-Jun-05 2
15-Jun-05 12
16-Jun-05 25
17-Jun-05 7
Grand Ttl 46



"Natarajan" wrote:

the column just has entries in YMD format. I can change and sort the format.
Beyond this, I need to count how many entries are there for each date. Below
is a portion of the data

17-Jun-05
17-Jun-05
17-Jun-05
17-Jun-05
17-Jun-05
17-Jun-05
17-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
16-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
15-Jun-05
14-Jun-05
14-Jun-05



"TRE" wrote:

If the visitor sheet has multiple entries for each date, because each person
signs in with the day, try using a pivot table with count in your data area
and date as a row heading. Or, if one line in the visitor book can have more
than 1 visitor (e.g. a group is signed in), use sum in the data area. The
pivot table can also be sorted by decreasing number of visitors.

"Natarajan Ganesan" wrote:

I have imported the site vistor data into a spreadsheet. I wish to sort the
dates by number of visits for each day. So I would probably end up counting
the visits for each day. What function in Excel allows me to do this?