Having troubles on a Pivot. I have 500+ lines of sales data. I'm creating a Pivot that summarizes Part number on order, the quantity on order, and the dates they need to ship out.

The issue are the Ship dates. I want to view the results by each day, not summarized by month.
Within the Pivot, I'm adding the ShipDate to Columns. Unfortunately the columns are still getting summarized by Month totals versus listing out totals for each date.

Here's what strange. Within the PivotTable fields, there are two new fields that got created: Quarters and Years. I have no idea how these came into the table, I have no column heading within my data sheet. I'm quite sure these two new fields are causing a problem.
If I copy my data to a new spreadsheet and create a new Pivot, there is no trouble with dates showing in each column. And there are no new fields of Quarters and Years showing up.

Any idea what went wrong with the original pivottable? thanks