Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AR Aging Report Design Issue | Excel Discussion (Misc queries) | |||
Aging Report | Excel Discussion (Misc queries) | |||
Organization of Aging Report | Excel Discussion (Misc queries) | |||
creating an aging report | Excel Worksheet Functions | |||
Help with Aging Report | Excel Worksheet Functions |