Check if referenced cell is empty on a specific date

[streakotter]

Hoping someone can help me.

I want to set up a formula that prompts me to send a reminder email, however, there are some factors.

excelexample.PNG

Basically, I want to send a reminder email if column B is blank (i.e. item has not been returned) and it is the date (today) in column C.
But, the email is not required if column B is not blank (i.e. item has been returned).
I was hoping that column D could say "Yes" or "No" based on these parameters.

[Bo_Ry]

Please try at D2
=IF(AND(B2="",C2<=TODAY()),"Yes","No")

[streakotter]

It worked. Thank you very much!