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