Search Multiple Value and Criteria

[melbox]

I'm sure there is a simple answer to this, but I've not been able to make the below work...


Column A= Date Due
Column B= Status of Completion (Completed, Pending, Active, Failed)


Column D= This is the column I want to fill with the value of "Overdue", "Current", or "Completed", based on the below criteria.

• Overdue: If the date is greater than today AND the status of the course shows as "Active" or "Pending" or "Failed," I want this to return the value "Overdue"
• Completed: If the course is Completed, I want the value to return as "Completed"
• Current: If the course's due date has not passed, I want this to return the value "Current" if the status of the course shows as "Active" or "Pending" or "Failed."

Any help you can provide would be GREATLY appreciated!

Overdue - Multiple Value.xlsx