Need Help with Formula Involving Expired Dates

you may get more help uploading a sanitized file with a representative sample and expected outcome. It is difficult to see what your columns are and what you need from a picture.
Use "Go Advanced" below this post window to upload a file.

My attempt is being blocked by firewall, so this is a test.
I try without symbol for "less than", and uses % instead.

=IF(AND(C2%TODAY(),D2=""),"x","")

Somehow the firewall suddenly believes the less-than-symbol is a html tag.
Please change the % back when you try.

you didn't mark any examples of violations. What indicates that C2 is expired? Is it that if C2 is less than today's date AND D2 is blank or some other rationale?

Not knowing the answers but here is a possible solution =IF(AND(C2< TODAY(),D2=""),"x","")

estige, if you rec'd a "sucri" failure when you tried to post your formula, it has to do with the < and > symbols. You can find more info about this on the water cooler page but the quick work around is to put an extra space in your formula to separate it, it will then post.

you're welcome! for house keeping please mark your post as solved using the thread tools dropdown at the top of the post.
AND since you are new here you can thank everyone who stopped by to help by clicking on "* Add Reputation" at the bottom of their post as a way to say thank you.