RT New Log 111805.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
F | G | H | I | J | K | L | M | N | O | |||
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 | |||
4 | ||||||||||||
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 | |||||||
Current Cases |
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.
rthakur