Group dates by TWO months in a PivotTable

[Axel]

Hi, how can i group date by TWO months, using Excel 2007 in PivotTable Options -> Group -> Group Field appears only this options:

• Seconds
• Minutes
• Hours
• Days
• Months
• Quarters
• Years

If i select months group by 1 month
If i select Quartes group by 3 moths

I wish group by 2 months



My data is something like this:

<table border="0" cellpadding="0" cellspacing="0" width="75"><col style="width: 56pt;" width="75"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 56pt;" align="right" height="20" width="75">10/03/2006</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">16/03/2007</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">08/06/2006</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">08/06/2007</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">21/08/2006</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">23/08/2008</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">16/11/2006</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">22/01/2008</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">26/01/2008</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">27/02/2008</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">27/02/2007</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">01/04/2007</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">14/04/2008</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">23/04/2008</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt;" align="right" height="20">18/05/2008</td> </tr> </tbody></table>
Thanks in advance!

Regards

 

[CWatts]

For what you want to do, you're going to want to set up a specific column so you can use it as it's own field.

Assuming all of your dates are in column A, you can use the following formula to find out what pair of months they're in:

=LOOKUP(MONTH(A1),{1,3,5,7,9,11},{"Set 1","Set 2","Set 3","Set 4","Set 5","Set 6"})

January/February would be named "Set 1"
March / April would be named "Set 2"
and so forth

Hope that helps.