You did not mention your version.
In XL2003
Simply click on a date and use the sort icon from the standard toolbar.
OR
1) Right-click on the date field heading
2) Click "Field settings"
3) Click "Advanced..."
4) Choose "Ascending" or "Descending" and check your date field shows in the
"Using field" list box before pressing OK.
IF DATA ARE NOT IN DATE FORMAT, the result will be sorted alphabetically. If
so, this MAY help
http://office.microsoft.com/en-us/ex...165021033.aspx
--
Steve
"acss" wrote in message
...
Hi,
I am trying to create a pivot table of of some small data and when it is
created it unsorts the dates. In my data sheet i have it as January 2008,
February 2008,March 2008 etc yet my columns in the pivot are not in that
order....how can i place them in the correct order?