|I have to make a number of assumptions before I can offer a solution:|
I assume that your use of Column numbers (1-5) relate to the Column letters, A-E.
I assume that you have Column headings in Row 1 (Name, etc.)
I assume that an entry of Yes means Valid, No means Expired.
If all of that is correct, enter this is D2 and drag it down:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.