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.
--
David Biddulph

"ls" wrote in message
...
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" wrote:

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.
--
David Biddulph


"ls" wrote in message
...
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.