Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count data based on past dates | Excel Worksheet Functions | |||
Averages based on dates | Excel Worksheet Functions | |||
Calculating Due Dates Based on Payments | Excel Worksheet Functions | |||
Totals based on dates | Excel Worksheet Functions | |||
How do I ensure dates inputted are during the work week? | Excel Worksheet Functions |