Excel question re: pivot table date field list

Factual Questions
1

I keep a list of my transactions in a worksheet, and want to use a PivotTable to figure out earnings by week. Currently, I have data from last October through today, about 1000 entries in all.

The Date field list on the PivotTable is not in order, which makes selecting dates very inconveinent. Here is an example of a short section of the list:

1/25/2003
1/29/2003
1/3/2003
1/30/2003
1/31/2003
1/4/2003
1/8/2003
1/9/2003
10/10/2002
10/11/2002

etc.

How do I sort that list to be in calendar order?

Thank you in advance.

Seth Dallob

2

I think you need to do it before hand using Data Sort…Highlight the section (CTRL-*) and then Data > Sort by the date column.