Formula to calculate Aging Buckets

[tomlinsn]

I know I have seen this before, but can't put my fingers on it today.

I have a large aging report that I want to summarize into aging buckets -- i.e. 30, 60, 90 days.

I know how to calculate the difference in dates, but I don't know how to convert 25 days into the 30 day bucket, 45 days into the 60 day bucket, etc.

Thank you in advance for your assistance!

Tom

 

[tomlinsn]

I found the answer:

=IF(TODAY()-B8017<=30,"0-30 days",IF(TODAY()-B8017<=60,"31-60 days",IF(TODAY()-B8017<=90,"61-90 days",IF(TODAY()-B8017<=120,"91-120 days",IF(TODAY()-B8017<=150,"121-150 days","over 150 days")))))

Assuming B8017 has the date I want to evaluate for aging purposes. This worked and allowed me to sort and subtotal as I wanted.