Hi Steve:

I tried that doesn't calculate correctly, thanks.

"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