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

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#real-time data collaboration
#pivot table
#timestamp
#date
#Column A
#results
#unique
#count
#editing
#removing
#appear
#edit
#help
#03/01/2026
#time