If statement with dates based in order

[ramosca]

I am trying to figure out how to calculate an if statement using dates.

A2 = promised date
B2 = completion date
C2 = status

If the completion date is before the promise date then the status should equal = "on time"
If the completion date is after the promise date then the status should equal = "late"
if the completion date is blank the status should equal = "late"

Thanks for your help in advance

 

[Andrew Poulsom]

Like this?

=IF(ISNUMBER(A3),IF(A3<=A2,"On time","Late"),"")

 

[Gerald Higgins]

Let's assume you actually mean

"If the completion date is before OR THE SAME AS the promise date then the status should equal = "on time" "

=if(or(b2="",b2>a2),"late","on time")

 

[ramosca]

Thank you so much it works like a charm.
Sorry for not being clearer.