sorting dates on a pivot table

[smdoung]

Hi,
I'm trying to sort dates on a pivot table, but its not sorting.
They are in this format from Google Analytics.

Monday, January 24, 2011
Tuesday, January 25, 2011
Wednesday, January 26, 2011
Thursday, January 27, 2011
Friday, January 28, 2011
Saturday, January 29, 2011
Sunday, January 30, 2011
Monday, January 31, 2011
Tuesday, February 1, 2011
Wednesday, February 2, 2011
Thursday, February 3, 2011

Does anyone know how to sort that? Or, do I need to convert it to another format first? If I need to convert, how do I convert?

Thanks!

 

[GlennUK]

They are strings ... do Data/Text To Columns, option Delimited, with delimiters of Space and "," and treat consecutive delimiters as one. Set the first field as "Skip" and then perform the conversion. You will have 3 columns of data ( make sure that you have room to do this ... i.e. have empty columns to the right of this data when you do this operation ) ... and then join the 3 columns like this to make a real date:

=DATEVALUE(B1&"/"&A1&"/"&C1)

and format as a date in whatever format you like ( Cell formatting ). It will then sort how you like.