Setting expiry date with conditional formatting

Hi,
Find the attached which is an example of what you want. I've created 100 people with random dates as a Table. Then next to it is a Criteria with the correct syntax for the filter.

Now you need to look at the Advanced filter to see how it works. You need to tell the Advanced filter where the data is, where the criteria is and where you want to put the answer.

I hope this helps.