If you look in my sheet, there is a field called dispatch. In that column are dates I need to count the days from the current date to that date listed in the column and populate the fields below. Keep in mind the number of rows changes daily so I would need this to work dynamically.
I need to know how many :
Tickets open 1-2 Days
Tickets open 3-5 Days
Tickets open 6 -10 Days
Tickets 11+ Days
I also need to average out DISPATCH DELAY column.
Thanks in advance for your assistance!