•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
problem with pivot table date columns
i 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
thats the view from the forula tab, idk why they still count the days, how do i solve this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#financial modeling with spreadsheets
#pivot table
#date columns
#Excel
#mm/yyyy
#mmm/yyyy
#full dates
#date format
#counting days
#data analysis
#different columns
#data processing
#data aggregation
#data manipulation
#data types
#formula tab