Need help in fixing my formula

Hi,

Below is the screenshot of my spreadsheet.

What I wanted is that in the Status Column, it will state "Pending" if the "Date Redeemed" column is blank and today's date is within the Valid From Column and Valid Until Column.

Below is my formula but I don't know how to factor in the DAte Redeemed Column which is my column L.

=IF(OR(I14<=TODAY(),J14>=TODAY()),"PENDING")

Capture.PNG

I am hoping someone can help me. Thank you.

=IF(AND(I14<=TODAY(),J14>=TODAY()),L14=0, "PENDING")

I tried the above but it will state TRUE instead of PENDING

You are a legend!

Thank you so much for your help.