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.