I am creating an aged ticket report for my manager. I first calculated the Days open by using the formula =NOW()-A2, where cell A2 is the created date in yyyy/mm/dd format, which is rounded up to the nearest number. I then want to calculate the date range each ticket is open, 0-3 days open, 4-7 days open, 8-15 days open, 16-30 days open, 31-60 days open, 61-120 days open and >120. Both of these formulas are in cells q and R. Here is the formula:
When I run the formula it works great, but when I go to sort on the column I would like the data to sort from the lowest to the highest date range, but when I sort the ranges are all mixed up. I mean they are grouped by the range but, for example the date range 61-120 comes first and then the date range 31-60 comes next.
How can I sort these so they are arranged either from the highest to the lowest or vice versa?