Sorting by Date in Pivot Tables

J

JuliaW

I have a worksheet I would like to make a pivot table from. My problem
is that when I do it, the months and years don't appear in calendar
order but rather alphabetical order (i.e., April comes first, January
is further down). How can I format this to have the pivot table show
January of 2002, rest of 2002 and then start January 2003?
 
B

Bernie Deitrick

Julia,

If you entered the dates as string values, then Excel will sort them as strings. If you enter the dates as dates, then Excel will
sort by date.

Format the cell with January 2002 as Number. If it stays January 2002, then your 'dates' are actually strings. When it changes to
37257, then you have actual dates, and Excel will work as you expect.

HTH,
Bernie
Excel MVP
 
Y

you suck

if yoiu change the format to yy-mm-dd or yy-mm then it should sort by year
then month
 
Top