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