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.