Sorting by Date in Pivot Tables

  • Thread starter Thread starter JuliaW
  • Start date Start date
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?
 
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
 
Back
Top