Column or Row, with partial information

[Crispy85]

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!

[benishiryo]

hi Crispy85. you can right-click the dates & group them.
http://chandoo.org/wp/2009/11/17/gro...-pivot-tables/

few rules in your source though:
1. no blanks within the range should be in the column where the dates are
2. the dates must be date formatted

[Crispy85]

Ok! Great thanks!