WORKDAY excludes holidays, it is the 3rd argument

=WORKDAY(A1,5,holiday)

where holidays is a rang of holiday dates.

--
HTH

Bob

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

"Chickadee" wrote in message
...
I have a set date to which I need to add a number of days, but holidays
should not be counted. The cells of one of the columns in my spreadsheet
holds the number of days, and I'd like to have results returned in the
cell
in the neighboring column.

Something like this:

8/2/2008

5 8/7/2008
10 8/12/2008
30 9/2/2008 (30 days is 9/1, but that's a holiday, so 9/2 is
right)

Any ideas?

I had been doing A1+B1 and it worked fine until I ran into needing to add
Business Days instead of "regular days". So, I stared using
=WORKDAY(A1,5).
Neither excludes holidays though. Is there any way to have the number of
days argument be a reference to another cell (b1 in my example) rather
than
having to put it in by hand?

Thanks!
J