IF statement and date formatting

Hi,

I am trying to use an 'IF' statement to look up a date and return a Yes/No if the date exists.

The 'IF' statement is looking at a cell whose data is being found by a 'VLookUp'
See attached file.

The problem I am having is the 'IF' statement is not picking up the month even though it exists in the cell. The date is formatted - mmm.

I think it may be a formatting issue but not sure how to resolve.

Terry

Thanks, works great.
Terry