Why not use a formula in another column

=IF(A1TODAY()-90,1,IF(A1TODAY()-180,2,IF(A1TODAY()-365,3,4)))

and then drop it into a pivot table for analysis using that new column as a
grouping factor

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ankur" wrote in message
...
i have a worksheet of Good receipts in which i have to do ageing of
various
items in following manner - 90 days,90 to 180 days, 180 to 365 days, above
365 days. Then i have to do sorting & thereafter subtotal.

i have to prepare this report on monthly basis......i can set the macro
but
main problem is that no of rows in a worksheet are not same, sometimes it
may
be less or it may be more.

any solution to this???