macro related

A

Ankur

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???
 
B

Bob Phillips

Why not use a formula in another column

=IF(A1>TODAY()-90,1,IF(A1>TODAY()-180,2,IF(A1>TODAY()-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)
 
A

Ankur

thanks bob for your response.

is it possible that instead of today i put some particluar date in that
formula, i tried but was not successful.
 
M

Mangesh Yadav

Yes. try:

=IF(A1>DATE(2005,8,17)-90,1,IF(A1>DATE(2005,8,17)-180,2,IF(A1>DATE(2005,8,17
)-365,3,4)))

for todays date.


Mangesh
 
Top