Hi everyone,
I am working a spreadsheet with actions and deadlines in Excel 2003. In column I is the original due date, column J contains new due date and column K contains completed date. I need to add a status column that clearly shows if the action has been completed, is on going or if it's late. My idea is to create a nested if statement that returns a 1 if the action is completed, 2 if its on going, and a 0 if it's late. From there I can use conditional formatting to make the status cell green for completed, red for late, etc.
The statement that I came up with is the following but it keeps giving me an error.
IF(k5 < TODAY(), 1 , IF(or(j5 > today(); i5 > today()), 0,2))))
Any help would be greatly appreciated.
I am working a spreadsheet with actions and deadlines in Excel 2003. In column I is the original due date, column J contains new due date and column K contains completed date. I need to add a status column that clearly shows if the action has been completed, is on going or if it's late. My idea is to create a nested if statement that returns a 1 if the action is completed, 2 if its on going, and a 0 if it's late. From there I can use conditional formatting to make the status cell green for completed, red for late, etc.
The statement that I came up with is the following but it keeps giving me an error.
IF(k5 < TODAY(), 1 , IF(or(j5 > today(); i5 > today()), 0,2))))
Any help would be greatly appreciated.
Last edited:
