View Single Post
 
Old 01-17-2022, 03:12 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

You've formatted a number eg.2005 as a date (yyyy) so it's converting the date number (2005) which is 27th June 1905, and only showing the year part (1905).
In the pivot table, go into the field settings for Year, and change the number format back to a plain number or General).
2022-01-17_225824.png

But I'm fairly sure you're using a fairly up-to-date version of Excel and you can dispense with your 2 added columns by grouping the date column. I've added another example pivot table which is based only on source data columns A:G with such grouping.
Attached Files
File Type: xlsx msofficeforums48329Sample_Pivot_Dates_Check.xlsx (34.3 KB, 8 views)
Reply With Quote