I'm trying to find a way to calculate the count of tasks that are "aging." In essence are past due but in tiered ranges.
I need to know the number of tasks past due in the following ranges:
- 0-30 days
- 31-60 days
- 61-90 days
- 90+ days
I can calculate the number of tasks that have due days in those overlapping ranges. For example, I can easily calculate the tasks due in the past 30 days. Then, calculate the number past due in the past 60 days. But then I end up with overlapping values, as some of the tasks counted in the "past 30-day" rage are also included in the "past 60-day" rage.
I'm missing something simple, but I can't seem to nail this down.