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.