IF Formula in Excel

[ashani]

Hi experts,

I wonder if someone could help me with IF formula, here's the example :

If column A says Completed by assigned date in Column B then Column C should say Completed.
If completed after due date then Column C should say "Completed after Due Date".
If Column A says Outstanding and before the assigned date then in Column C it should say "Complete ASAP"

thank you

 

[MountainFog]

You are asking excel to keep track of when a cell value was changed, and that is either vba or an additional cell where people input the date completed

 

[Scott Huish]

You only have 1 date column: Date completed by. Shouldn't there be a due date and a completed date column?

 

[ashani]

there's an additional column in R1 which has today's date

 

[MountainFog]

There should be a completed date column