ageing report

Dear all, pl. help me this.

I have three columns

Item No. > Date of issue > Qty

Now i want ageing report like;
Qty issued on every three months gap.

e.g. qty issued
Item No. 3months 6 months 9months

regards.chirag

Can you define your intervals? Is it a rolling 90 days for each 3 month period? Or maybe current month and then the last 3 full month, last 6 full months, then last 9 full month?

I've attached a spreadsheet that demonstrates both conditions I inquired about.

I used the SUMPRODUCT() function to calculate the quantities.

Here is the formula I used to determine the last 90 days.

Please Login or Register  to view this content.

Current month:

Please Login or Register  to view this content.

Last 3 full months:

Please Login or Register  to view this content.

The formula calculates the quantities for the last 3 full months and then subtracts the current month's data. For this example, cell G8 contains the total from the current month.