Issue With Date In Pivot Table

[tomohawk]

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