•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Editing date inside pivot table
Our take
Are your pivot tables revealing more detail than you need? When timestamps clutter your data, it can obscure the insights you seek—like counting occurrences of specific days. In this guide, we’ll explore how to edit your pivot table to remove those timestamps, allowing you to view the count of each date at a glance. By simplifying your data, you not only enhance clarity but also unlock valuable insights. Let’s dive into the steps to transform your pivot table and streamline your analysis.
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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- problem with pivot table date columnsi had full dates, then i made them only mm/yyy type, but when put in the pivot table they still count the same month as different columns because they still count the days in, even though i changed it to mmm/yyy https://preview.redd.it/jds1lkbg9xtg1.png?width=1088&format=png&auto=webp&s=869a4bf431c54e6e9603d3cb25fe2bc53981b64b https://preview.redd.it/l8px4ijk9xtg1.png?width=164&format=png&auto=webp&s=01a8e47a9b24ba184aa097af2c212e453ec1c4b2 thats the view from the forula tab, idk why they still count the days, how do i solve this? https://preview.redd.it/wtsz4wrl9xtg1.png?width=283&format=png&auto=webp&s=5cd03a6a328ee992de70b209e429441f11294188 submitted by /u/PurpleDurian7220 [link] [comments]
- Pivot Table top bar date filter doesn't update in chronological orderI have a an excel file which I had been building from scratch from a downloaded report every month and am trying to better automate since I do the same type of data filtering each month. I decided to create a table with the data that is linked to a pivot table which sorts and filters it into the format that I need as long as I manually adjust a couple things. However, whenever I add new data to the table, the date filter at the top of the pivot table does not show in chronological order. (Accountant working on April data and need to remove anything that was posted in May.) Theoretically I could use the timeline feature, but I'd rather not. I have resorted the source table in chronological order; I have removed the filter and re-added it in various formats. I've changed the data source, played with various settings. Is there a quick "fix" for this without manually creating the pivot table each time? I have several of these pivot tables on a sheet extracting different data sets sourced from the same table. In one of them, I need to see ONLY the items with a May date, so having to scroll through to check or uncheck the correct dates if they are out of order could lead to errors. Additionally, assuming that this can be corrected. Is there a way for an excel sheet to automatically add or remove row (by hiding or deleting, don't care which) as a pivot table gets longer or shorter so I don't have to guess how many rows I need to add before it cuts into other data below it? Sometimes I need 70+ rows and others only 30. I'm sure there's an overall better way to do what I'm doing. Thanks in advance. https://preview.redd.it/56optogx0qzg1.png?width=406&format=png&auto=webp&s=551180d29effbcfedb7038f60612e33f4e897d3d submitted by /u/inez6453 [link] [comments]