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?