Sorry, guys, I guess I wasn't clear. It's not the holidays part that's
stumping me, I get that.

What I need is a function that works like WORKDAY (in that there are
arguments you can use - including "holiday"), but that is just for plain old
days (not just workdays). I also need to know how, if possible, to point the
second argument (the number of days to add to the fixed date) to a number in
another cell rather than typing it in the formula by hand. In the
alternative, can you add a holiday argument to a simple formula like A1+B1?

By way of explanation: I use this spreadsheet as a template for real estate
closing checklist/deadlines so the number of days from the fixed date for a
given event to occur is not the same for different deals. Sometimes earnest
money is due 5 days from the date of signing, sometimes 10 days. I would
rather change the "5" to a "10" in it's own cell than have to change the
argument in the date calculating function in the neighboring cell.

"Bob Phillips" wrote:

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