Reply to thread

Message: [QUOTE="Shelly, post: 3191663"] I now have it sort of working with this formula: =IF(AND(L7<(A1)-L7>60),"Pending",IF(AND(L7>(A1)-L7<180),"FollowUp",IF(L7>=(A1),"Completed",0))) My problem now is that it isn't calculating the dates correctly it is showing all cells as being "pending" (i.e. when I put in the date 1/2/2006 it is still showing as "pending" instead of "completed"). I also would like to see if I could use the "stop light" coloring with this as well and have yellow for the pending section, red for followup and green for completed, if possible. [/QUOTE]