Hi. I've been struggling with this issue for days and despite discovering a number of 'solutions' on the web I still have the same problem...

I have a table of data that has been extracted from SQL with one field being the 'Date' field. I have then put this data into a pivot table with the dates running across the top, sorted oldest to newest - which works fine.

I can then group these dates by week (7 days). But when I have them grouped they are sorted by alphabetical rather than date order.

I have done everything I can think of to ensure that the date field contains data in date format (and the fact that I can group by week suggests Excel reads them as dates), there are no blank items in the field.

I am using Excel 2010

Thanks in advance!