Hi all,

Any help with this one much appreciated.

I want to validate the data in cell B1 so that entry is prevented if the
date in Cell A1 does not appear in a named range of dates in a different
sheet in the same workbook. I assume that something with =MATCH will do the
job but can't figure it out - can you?

TIA,

Andrew