dominic_aca
New Member
- Joined
- Jan 20, 2010
- Messages
- 2
HI...can anyone help me with a formula for aging data in days (to be aged based on current date vs. for eg., Invoice date)
Thanks Jonmo1 - was looking for more comprehensive formula like - we have the aging days based on ur formula below. How do we split it further in ranges of say 0-30 days, 31-60 days, 61-90 days, 91-120 days and > 120 days (data to be split based on aging days into different columns using either IF formula specifying ranges...?)