=ISNUMBER(MATCH(date_cell,holiday_lits,0))

will return TRUE if it is a holiday



--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"louise" wrote in message
...
I hope that someone can help me with the following:

When filling in a specific date I have to tjeck for holidays which are
filled in, in another sheet. Is there a special function for this?

--
Regards Louise