richmcgill
Board Regular
- Joined
- Feb 4, 2019
- Messages
- 71
- Office Version
- 2016
- Platform
- Windows
I need help with a formula or formulas to count and categorize aged dates based on the aging range below.
There is a fixed date at the top of the report that it will be compared to that is not a today formula.
There is a lot of information above and below where this information will be pulled from so a pivot table is not ideal.
<tbody>
</tbody>
Populate count here.
<tbody>
</tbody>
There is a fixed date at the top of the report that it will be compared to that is not a today formula.
There is a lot of information above and below where this information will be pulled from so a pivot table is not ideal.
Date |
5/7/2019 |
5/20/2019 |
3/1/2019 |
4/15/2019 |
5/24/2019 |
5/29/2019 |
5/30/2019 |
6/7/2019 |
5/30/2019 |
6/3/2019 |
<tbody>
</tbody>
Populate count here.
Days On Report |
0 Days 1-7 Days |
8 to 14 Days |
15 to 21 Days |
22 to 29 Days |
30 Days and Over |
<tbody>
</tbody>