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

leslieyosbe Wrote:
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.


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=567972

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(C1B1,"Late","Ok")

Hope one of the two ideas help?

Regards

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=567972