ageing analyses in excel 30-60, 60-90, 90-120

[shripaldalal]

hi,

i require to know what category my due dates fall in, 30-60, 60-90 or
90-120 ?

i already know how to do this, with a formula like:

if(and(days360(AJ2, now()) > 30, days360(aj2, now()) < 60), "30-60",
"")

same with 60-90, 90-120

the problem starts here:

my users may want to put in their own ranges, like 0-15, 15-30, 30-45,
45-60, 60-75, 75-90

also the range may go on and on to any extent.

How can I achieve this ? I just dont know where to start, VLOOKUP,
MATCH ?????????

regards,
shripal.

 

[Bob Phillips]

=LOOKUP(TODAY()-A1,{0,31,61,91;"0-30","31-60","61-90","90-120"})&" days"

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[shripaldalal]

Bob,

Thank you very much, works like a charm!

Best regards,
Shripal Dalal.