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.

=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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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,

Thank you very much, works like a charm!

Best regards,
Shripal Dalal.