|RT New Log 111805.xls|
|2||Review||1st Letter||21 days||Date 2nd||42 days||Open||Date of last||To U/W||Days in|
|3||Start Date||Sent||2nd Letter||Letter Sent||Deadline||Tickle||Activity||U/W||Action Status|
|5||9/1/05||9/5/05||9/26/05||9/28/05||10/19/05||Consult With Manager - Over 42 days!|
|6||1/3/05||7/5/05||7/26/05||6/1/05||Send Second Letter|
Under O" column I am having trouble getting the expected message.
This is what I am looking for in "O" column.
if F5 is empty = *No message Displayed*
If F5 is filled with date and G5 is empty = "Case Logged - Pending Review"
If F5 is filled with date and G5 is also filled with date = "Review Initiated"
If today() >=21 days from G5 = "Second Letter" however if within 21 days from G5 = "No action Required"
If I5 is filled with date and today() >= 21 days from I5 = "Consult with Manager" however if within 21 days from I5 = "No Action Required)
I would still like to keep the beginning of this formula to give preference to =IF(Q5="y","Case completed",IF(M5,"Referred to U / W").
Thank you for all your kind help.