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…