Forum Discussion
IF AND function
I have two columns on my excel, one is to show the Task Due Dates and other one to show the Actual Completion Dates. If I were to add the third column to show "Late" if the Task Completion column date is later date than the Task due date column. What is the easiest way to formulate the third column?
Hi,
You may use conditional formatting https://support.office.com/en-us/article/Use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f to highlight such cells/rows.
If third column the formula could be
=IF(Task Completion Date > Actual Completion Date,"Late","")
- Thank you. it helped. :)
