Compare dates based on statuses & work out whether achieved on tim
I have 3 columns:
Column 1 has 'date submitted'
Column 2 has status e.g. urgent, high, medium, low
Column 3 has 'date implemented'
The statuses in column 2 have values, e.g. Urgent = 2 days, High = 5 days,
Medium = 10 days, Low = 10 days
I need to be able to establish whether statuses were adhered to, e.g. if a
task was urgent, was it completed within 2 days; if a task was high, was it
completed within 5 days.
Thanks in advance.
|