Date Status Update

[Kgreen214]

I am trying to set up a Spread sheet that will return 3 different values in the Date Status column (column G) based off of information on the spreadsheet.

Not Due - If the End Date column (Column F) date hasn't Passed
Overdue - If the End Date column (Column F) date has passed
Closed - If the End Date column (Column F) date has passed but the task status column (Column H) has been marked as "complete"

Any help with this would be great. Thanks!

 

[Trebor76]

Hi Kgreen214,

Here's one way:

=IF(F8<TODAY(),"Not Due",IF(AND(F8>TODAY(),H8<>"Complete"),"Overdue","Complete"))

Regards,

Robert

 

[Kgreen214]

Hi Kgreen214,

Here's one way:

=IF(F8<TODAY(),"Not Due",IF(AND(F8>TODAY(),H8<>"Complete"),"Overdue","Complete"))

Regards,

Robert

Thanks.