Steve,

Much simpler than mine but it doesn't quite work, try this modification

=WORKDAY(A1+100,0,Holidays)+CHOOSE(WEEKDAY(WORKDAY (A1+100,0,Holidays),2),0,0,0,0,0,2,1)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Steve Dunn" wrote:

Missed holidays

=workday(A1+99,1,Holidays)


"Steve Dunn" wrote in message
...
Perhaps, untested:

=workday(A1+99,1)




"Darrell" wrote in message
...
I want to add 100 calendar days to a date in a cell and when that date
falls
on a weekend or holiday the formula will return the next workday vs.
returning a weekend date.

I tried the workday function but it counted 100 workdays not calendar
days.

Thanks in advance