Formula that returns late, early or Ok accordingly to the period

I need a formula to automatically calculate if the Job was completed in the
date range that was provided, and to return Early, Late or Ok accordingly.

If we assume that the expected date of completion is in A1 and the actual date of completion is in B1 then the formula you want should be

=IF(B1-A1<0,"Early",IF(B1-A1=0,"Ok","Late"))

Hope that is what you wanted?

Regards

Carl

Originally Posted by leslieyosbe

I need a formula to automatically calculate if the Job was completed in the
date range that was provided, and to return Early, Late or Ok accordingly.

Although loking again at what you asked this might not be what you wanted. If you wanted to test if the completion date was within two given date ranges

If we assume in A1 is the earliest completion date, B1 is the latest possible completion date then the formula would be

=if(C1<A1,"Early",if(C1>B1,"Late","Ok")

Hope one of the two ideas help?

Regards

Carl