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.

=SUMPRODUCT(($A$2:$A$1600=$F2)*($B$2:$B$1600>=TODAY()-90)*$C$2:$C$1600)

Current month:

=SUMPRODUCT(($B$2:$B$228>=TODAY()-DAY(TODAY())+1)*($A$2:$A$228=$F8)*$C$2:$C$228)

Last 3 full months:

=SUMPRODUCT(($B$2:$B$228>=DATE(YEAR(TODAY()),MONTH(TODAY())-3,1))*($A$2:$A$228=$F8)*$C$2:$C$228)-$G8

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.