View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kierano Kierano is offline
external usenet poster
 
Posts: 29
Default 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.