Question: how to change the date format in pivot table?
Answer: Right-click a cell in the date field of the pivot table. Choose Field Settings… Click the Number Format button. Change the Date formatting in the Format Cells window. Press OK and OK.