Thread: Aging Report
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liz J[_2_] Liz J[_2_] is offline
external usenet poster
 
Posts: 36
Default Aging Report

I'm trying to perform an aged payable analysis as of 9/30/09. In column A of
my spreadsheet, I have dates (format: 1/1/2009). These dates go from 1/1/2000
to 9/30/2009. In column B, I have invoice dollar amounts.
My goal is to create a pivot table that has columns with the following data:
0-3 months, 3-6 months, then skip to 6-12, 12-18, and 18+ months.

How do I group that in a pivot table?

Thank you for your help!