If statement or conditional formatting

[morerockin]

Hello All,

I am in need of help coming up with either conditional formatting or a formula.

Please see attached. Book5.xlsx

In column C, I need it to return "Incomplete" if both columns A and B do not return a date greater than 01/00/1900. It should also return "Incomplete" if only one of the columns has a date.

If both columns return a date greater than 1/00/1900, than it should return "Complete" in column C.

Any help is much appreciated.

[cbatrody]

Hi,

Try the following formula in C2:

=IF(AND(A2>DATE(1900,1,0),B2>DATE(1900,1,0),A2<>"",B2<>""),"Complete","Incomplete")

[Special-K]

Not looked at your file

Try
in C1
=IF(LEN(A1)*LEN(B1)=0,"Incomplete","Complete")

[morerockin]

Hi,

Try the following formula in C2:

=IF(AND(A2>DATE(1900,1,0),B2>DATE(1900,1,0),A2<>"",B2<>""),"Complete","Incomplete")

This worked! Thanks!