@Kevin
As the OP explained, he wants to enter a date in a cell and check a range to see if that date is already there.
I'm afraid the solution you proposed will not help in this case

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post