I have a simple pivot table pulling from another Excel file. If the date in the source data is June 5, 2014 it is reflected in the pivot table as June 6, 2018. I have tried changing the "Use 1904 date system" under Options-Advanced-When calculating this workbook: and i does not fix. Anyone have any idea on how to resolve this issue?