Using Formatted Data in a Pivot Table

[gate68]

I am using a pivot table to count the date where an error has occurred. It counts the dates but the problem is that the date has a time attached to it therefore a single day may have several rows. I have formatted the table so it only sees the date but it is not working and does the same thing. i am also exporting this data to minitab if that helps any bit. I am using Excel 2003 and windows XP

 

[xenou]

Hi Welcome.

It is not clear exactly what you need. If there are errors on the same day, would you need to count all of them (regardless of time)? Or do you want to count only one (regardless of how many in the same day)?

In general, pivot tables are in their nature flexible and hard to explain. Often the easiest thing to do is work with your source data (against otherwise good principles). Add a column to the source data that would contain this formula:
=DATE(YEAR(A1),MONTH(A1),DAY(A1))

Or simply,
=INT(A1)

This will give you a column of dates without the times.

HTH

 

[gate68]

Thanks this helped a lot