'If function And, OR to know if task is delay or not based on Today date - Excel

Good morning

I have an issue writing a formula at excel,

I want to write an if statement ( if Today date > End date and status = In progress or Pending or new the result will be Delay )

  • I have the status as a dropdown list

  • this is a screenshot

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source