if condition formula result either completed or incompleted

"I HAVE CONDITION FOR RANGE A:B:C THEN RESULT IN D EITHER COMPLETED/INCOMPLETED

IF BAR ZONE IS ""TX"", PACKAGE IS ""VIRGIN"" TILL ONE DAYS EXCEPTION"

APART FROM "TX"AND "VIRGIN" TILL TWO DAY EXCEPTION

"IF ""TX"" MAY BE IN BAR ZONE COLUMN OR ""VIRGIN"" MAY BE IN PACKAGE COLUMN!
BOTH SHOULD NOT COME IN STRAIGHT LINE IF COMES IN STRAIGHT LINE CRITERIA SHOULD BE ONE DAY"


please find the attachment

any one help to solve it?

I need solution for this??? any one can help on this?