1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Editing date inside pivot table

Hi all, I have a list of dates in Column A. Cell A1 = 03/01/2026 3:00 PM. Cell A1 = 03/01/2026 5:00 PM. I created a pivot table to count how many time each day appears. Each item in the pivot table is unique because there is a timestamp on the date. For example: 03/01/2026 3:00 PM shows up once in the results of the pivot table. 03/01/2026 5:00 PM shows up once in the results of the pivot table. I want to see 03/01/2026 showing up twice in the pivot table result. I know I can how to easily remove the date from column A and then my pivot table would look like the way I want it. My question is: How do I edit a pivot table to remove the timestamp on each date? Thanks for your help!

submitted by /u/Hour-Initiative-2766
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article