Holidays
 

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..

Holidays
 

=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..

Holidays
 

Thank you...that worked

"Bob Phillips" wrote:

=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..