ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Compare dates based on statuses & work out whether achieved on tim (https://www.excelbanter.com/excel-discussion-misc-queries/114736-compare-dates-based-statuses-work-out-whether-achieved-tim.html)

Kierano

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.



All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com