Excel is probably seeing the dates in the source table as text. There
are some techniques here that you can use to convert the text to dates,
so they can be sorted correctly:

http://www.contextures.com/xlDataEntry03.html

Todd1 wrote:
I have used pivot tables quite a bit in the last year.
I have a pivot table with dates and can't get the sorting to work the way I
would like. I want it to sort in ascending or descending order, but it is
sorting like this:
9/19/2005
9/2/2005
9/20/2005
9/21/2005
9/23/2005
9/3/2005
9/4/2005
I have tried formatting the data source, and it is formatted using the
mm/dd/yyyy format.
Can anyone help? I would even be willing to send you the excel workbook if
needed.

Thanks. Todd



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html