=IF(ISNUMBER(MATCH(A1,holidays,0)),WORKDAY(A1,1),A 1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JB" wrote in message
...
I have a date and a list of holidays. If this date is a holiday, how do I
make the date change to the next WORKDAY?....The WORKDAY function needs
one
to add days to a date and then gives a result..