Question: how to change date to month in excel pivot?
Answer: Select any cell in the Date column in the Pivot Table.
Go to Pivot Table Tools –> Analyze –> Group –> Group Selection.
In the Grouping dialogue box, select Months as well as Years. You can select more than one option by simply clicking on it.
Click OK.