Hi,
I'm having trouble working out how to combine a if statement to return if works have been completed early, late, incomplete or completed.
so im working with the following info
planned date
early start date
latest completion date
First completed date
this is what I have created so far - =IF(F2="","Incomplete",IF(OR(F2<E2,F2=E2),"Completed",IF(F2>E2,"Completed Late")))
I'm just not sure how to incorporate early start date.
I'm having trouble working out how to combine a if statement to return if works have been completed early, late, incomplete or completed.
so im working with the following info
planned date
early start date
latest completion date
First completed date
this is what I have created so far - =IF(F2="","Incomplete",IF(OR(F2<E2,F2=E2),"Completed",IF(F2>E2,"Completed Late")))
I'm just not sure how to incorporate early start date.