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
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:
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!