I have a sheet for work that counts the number of days an account has been open with "=TODAY()-A35".
What I need is a formula that can move the value from column to column when it meets certain days open (>30 days, >60 days, >90days)
We already have it conditionally formatted to highlight yellow when the counter goes over the value limit on each column, then we move the equation over to the next and repeat 30 days later.
Ultimately it needs to continue counting as it progresses in age until the account closes. Does anyone have any ideas? There are hundreds of these every week and we don't want to manually move them anymore.
Bookmarks