![]() |
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