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