Pivot Table and Pivot Table dates are not in correct order

  • Thread starter Thread starter ls
  • Start date Start date
L

ls

I have a pivot table that has a date field that is coming up out of order.
The column is labeled week ending data and the week of 7/10/09 is coming up
before 7/3/09. I need to get this back in line because it is throwing my
charts off. Can you tell me what to do to correct it.
 
It looks as if you haven't got a date field, but you've got text.
You'll need to change the text to dates. The archives of this group will
tell you how.
 
Thanks David. I have date field specified in the M/DD/YY format. The dates
are in order for the months earlier in the year but fell out of order with
7/10/09 before 7/3/09. I have changed the date format to several different
formats and it didn't help. I checked my source data and the data formats in
the pivot table and pivot chart.
 
You are not interested in the *display format*; you are interested in the
*cell content*.

Look at =ISTEXT(cell_ref) and =ISNUMBER(cellref).
If it is a real Excel date, these will be FALSE and TRUE respectively; if
it is text, these will give TRUE and FALSE respectively.
 
Back
Top