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.