Hi,

Hopefully an easy one for you guys.

I effectively want to write a formula in excel which does the following as I've written below:

=IF([the date in this cell]=[any of the dates in this other range of cells],"X","")

Hope that makes sense and someone can help me out.

Thanks

Dan