Hi All,

I have a complaints database with two columns saying opened and closed
(Column A says Opened and Column B says closed). In each of these columns
there is a date giving the opened and closed date. I need to identify all
complaints that have been open for more than 10 working days on a weekly
basis to identify trends.
Obviously for weeks one and two (based on the normal annual calendar) there
wouldn't be any because they wouldn't have been open long enough but for week
4 any from the 1st week that are still open would be more than ten days old.
So for week 5 i would count any from weeks 1 and 2 that were still open, for
week 6 and from weeks 1-3 that were still open etc etc.

Hope this makes sense.

Cheers