Have you verified that the dynamic range includes only the cells you
expected?
How did you check the format of the dates?

PFL wrote:
The pivot table source is a dynamic range.I checked the format of all
the dates and they are recognised as date format in the pivot table
source and pivot table.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I used the info from your website to construct the dynamic range. The
range includes all cells I expected. Originally It did not due to data
in row 2000. I checked the formats of the data by Format=Cell= Date.
The dynamic range only has 10 rows of data at present

If you'd like to send me the workbook, I can take a look at it. Remove
the capital letters from my posted email address, to get the real address.

PFL wrote:
I used the info from your website to construct the dynamic range. The
range includes all cells I expected. Originally It did not due to data
in row 2000. I checked the formats of the data by Format=Cell= Date.
The dynamic range only has 10 rows of data at present



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html