Pivot Table - Date values shown as serial number

[robertgama]

I have a pivot table with a date value as one of the columns in the data that I want to use as a report filter.

For some reason the dates are showing as serial numbers rather than dates. The column of data is formatted as date and shows properly in the data but not pivot table.

Here is a picture of the pivot table:

Here is a picture of the data:

I looked in field settings for the field in the pivot table, but I don't see any format options:

Any help would be appreciated.

Thanks,

Rob.

 

[robertgama]

I see that I selected entire columns as the data source (since the data rows can vary for the end user), and when I select only the data up until the final row it works and shows the dates.

The filter does not show years and months however. Is that an Excel 2007 vs 2010 issue?

Thanks,

Rob.

 

[robertgama]

Figured it out. There was some data in the column that was not formatted as date and it was preventing me from grouping the data. I searched in the forum here and found a response by someone referring to this website for the solution:
http://www.contextures.com/xlPivot07.html#Problems

Just updated for reference.

Thanks,

Rob.