Good day!

I have had luck in the past with people helping me with my issue on this fourm so I am hoping someone here can help me with this I am sure obvious answer.

I am creating a database at work for expiry of various programs/courses. I have got that conditional formatting down but I am struggling to make D2 (if pers has course) change to yes, No, or expired depending on the dates. I have got it to say yes, and expired but the "No" part when no date is inserted in column E.

The following is the current IF function I am using in D2:

=IF(E4<=TODAY(),"Expired",IF(E4=TODAY(),"Yes"))

I see the issue, but I just am not sure how to use multiple IF's, never works for me.

Any help would be greatly appriciated!