Hi,

I know the title is a bit unclear but i don't really know how to describe it.

For instance, if i would want to make a pivot table, with as Columns different dates.
In my report, thousands of dates are included, so this would make a pivot table huge.
Is there somehow a way to use the date field but have excel only pick the months.

So, for example; there's a range of dates from 01/01/2013 till 31/01/2013. I want Excel to take 01 only.
I know i can do this by formula, but that adds another column to my report and i think there should be an easier solution.

Thanks in advance!