I am looking for Ageing report, which will show me the ageing tickets

Hi

Please see attached file with Ageing.

In Col Q1 you can specify how many days in each bucket.

Col L has single formula to get buckets

Col J & K are separated out col L.

We would need Col N to Q as a look up table for buckets. If required this can be moved to another sheet.

let me know if any questions.

Regards
GetWorkDone


If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon)...