Issue With Date In Pivot Table
I have a spreadsheet with a large amount of data from which I create a pivot table for analysis.
In the data, one of the columns contains a date and from that date, I use a formula "=YEAR(A830)" and I have it formatted as "Number"
However, when I use this field, in a pivot table, I get an incorrect answer (1905). In the sample attached, I should see 2018, 2019, 2020 and 2021.
What am I doing wrong?
Also, and for my edification, I would like to be able to use MONTH in the pivot table at some point. I currently use formula "=DATE(YEAR(A830),MONTH(A830),1)" and the cell is formatted as "MMM-YY". I suspect this is not the best way to get the desired result, especially for pivot table use.
Thanks
Tommy
|