In column A of Excel i have Due date and actual completion date in Column B what i am looking for is for the formula where

if actual completion date is on or before due date I need "completed" in column C

if completion date is greater than due date then " delayed completion"

if completion date is blank not completed

You do not need Conditional Formatting for this, just a formula. With your data like this:

A B C 1) Due Date Completion Date Status 2) 03/20/2016 03/23/2016 Delayed Completion 3) 03/20/2016 03/20/2016 Completed 4) 03/20/2016 Not CompletedPut this formula in cell C2 and drag down:

=IF($B2>$A2,"Delayed Completion",IF($B2="","Not Completed","Completed"))

See how that works for you.

Also, Excel questions are best asked in the Office Software forum.

MIKE

message edited by mmcconaghy

Here is an updated version, just in case both A2 & B2 are blank

or A2 is blank but B2 has a date.

=IF(AND(A2="",B2=""),"",IF(AND(A2="",B2<>""),"Due Date Missing!",IF($B2>$A2,"Delayed Completion",IF($B2="","Not Completed","Completed"))))

MIKE

message edited by mmcconaghy

thank you very much. it worked

Ask Your Question

Weekly Poll