So the output look like this typically we run the report on Friday to show the age of the queue each day, let assume we are looking at next Monday.

Feb 15th - Monday 62 days, Tuesday, 63 days Wed, 63 days, Thursday 63 days Fri, 63 days,

Feb 22nd - Monday, 65 days, Tuesday, 4 days, Wed 63 days, Thursday 62 days Friday 63 days,

This is then used to chart what the queue will be for everyday looking a couple months into the future/

The manual part s that in order to update everyday I have to manually look at the number of items in the queue at the oldest and then use my assumption of how many we will close each day to figure out what the age will be on Tuesday, Wed, Thurs, Fri, etc. Example

Day 83

64 Items