Question: how to change date format in excel for 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.