grouping by date in excel and removing time in a pivot table
- by Ashley DeVan
My data looks like this:
count Added Date
1 8/26/09 3:46 PM
2 8/21/09 6:50 PM
3 8/21/09 3:04 PM
4 8/21/09 3:21 PM
5 5/1/09 6:56 AM
6 5/1/09 8:12 AM
7 5/1/09 8:00 AM
8 5/1/09 8:18 AM
9 5/1/09 8:58 AM
10 5/1/09 8:58 AM
11 5/1/09 9:06 AM
12 5/1/09 9:44 AM
13 5/1/09 9:50 AM
14 5/1/09 11:17 AM
15 5/1/09 11:27 AM
16 5/1/09 11:29 AM
17 5/1/09 11:39 AM
18 5/1/09 12:10 PM
19 5/1/09 12:33 PM
When I do a pivot table, I cannot get it to sum by day, it breaks it up by minute. I've even tried parsing the field, but the time always creates an issue.
How to I get my pivot table to give me a count by day and ignore the time stamp?