Conditional Formula with dates and Blanks

[SeanLCA]

hello
I updated my condition ran into some issues.

I Need a formula that in Col C returns Clear if in ColA there is a Date and in ColB is a Date. ColC is Expires if ColA there is a Date that is Less Than Today and ColB is Blank. Sample Below.

Updated Condition:
If there is a Date in Col A that is Less than today's date, and in ColB is blank than in ColC I=Expired
If there is a Date in Col A that is Greater than or equal today's date, and in ColB is blank than in ColC =Clear
If there is a Date in Col A that is Less than today's date, and in ColB has a date than in ColC = Clear
If there is a Date in Col A that is today's date or Greater and in ColB has a date than in ColC = Clear
If there Blank in Col A and in ColB has a date than in ColC = Clear

Sample:

A1	B1	C1
12/13/19	12/12/2019	Clear
12/14/19	12/14/2019	Clear
12/16/19	11/13/2019	Clear
12/15/19		Expired
12/17/19	10/14/2019	Clear

 

[Fluff]

Duplicate Dates in a formula and blank cells in another

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).