I have a data validation list containg 10 or so values. I want to be able to dynamically remove one of the options in the list based on the contents of another cell.

In summary, if the date in a cell is after a fixed date one of the options in the dat validation list is not valid!

Can I do that somehow?