This should be easy but I have been beating my head against the wall on it. Here is my statement I'm using:
=IF(AND([TODAY]>[Due In],[Comp Date]=""),"NO",IF(AND([TODAY]<[Due In],[Comp Date]=""),"",IF(AND([TODAY]>[Due In],[Comp Date]>[Due In]),"NO","YES")))
Basically I am checking two date fields, due date and completion date, to make sure the project has been turned in on time. Based on the return the calculated field should populate with yes, no or stay blank. I get a syntax or function not supported error. Any help would be greatly appriciated.
at