rsharma017
New Member
- Joined
- Aug 7, 2017
- Messages
- 7
I have a set of transactions that are showing an aging bucket 0-30, 31-60, 61-90, 91+ based on the date entered on the spreadsheet. I would like to know if possible to show the date a transaction will roll/move to the next aging bucket.
A1 Date in 05/03/2021
B1 Aging Bucket : Has a formula that shows based on date what the aging bucket mentioned is. As of today 06/03/2021 its in 31-60 Days Bucket.
C1 - This is where i need help to show date when B1 will move to 61-90 Days bucket
This would be for any type ; for example the date in C1 to show when B1 will move from 0-30 to 31-60, 31-60 to 61-90, 61-90 to 91+
Any help will be appreciated.
A1 Date in 05/03/2021
B1 Aging Bucket : Has a formula that shows based on date what the aging bucket mentioned is. As of today 06/03/2021 its in 31-60 Days Bucket.
C1 - This is where i need help to show date when B1 will move to 61-90 Days bucket
This would be for any type ; for example the date in C1 to show when B1 will move from 0-30 to 31-60, 31-60 to 61-90, 61-90 to 91+
Any help will be appreciated.