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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Days Late 1
if question 6
Counting days between dates 11
IF Logic Function with negative time or early time 1
Conditional Format over Date Range 3
Applying colour to my Formula 7
Counting average number of days between 2 dates 3
Time formula over two days 6

Back
Top