Pivot Table and Pivot Table dates are not in correct order

[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.

 

[David Biddulph]

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.

 

[ls]

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.

 

[David Biddulph]

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.