I've kept this simple by assuming:
A1 & C1 can only be empty or contain a date and any entry into B1 will only
be a comment (text)

=if(A1 =
"","",if(and(A1<"",b1="",c1=""),"Outstanding",if( and(A1<"",B1<"",C1=""),"",if(and(A1<"",B1="",C1 <""),"Cleared","ERROR!"))))

I've added the error condition in case an operator should fail to erase B1
when adding a date to C1.

HTH

Giz

"jimar" wrote:

I'm having difficulty forming this statement and would be grateful for
assistance.

Cell D1 contains the formula
If cell A1 is empty then cell D1 remains empty
If cell A1 contains a date and cell B1 is empty then cell D1 returns
"Outstanding"
If cell A1 contains a date and cell B1 contains text then cell D1 remains
empty
If cell A1 contains a date and cell B1 is empty and cell C1 contains a date
then cell D1 returns "Cleared"

Thank you