For any Excel function (except DATEDIF) on which you need extra information,
you should always start by looking at the Excel help for that function. It
will explain the syntax, give examples, and often have a "See also" link to
related functions.
--
David Biddulph

"Rotata" wrote in message
...
Thank you much for the example. Not only does it work beautifully, I now
have
a better understanding of "range".

"T. Valko" wrote:

The holidays argument should be a reference to a range where you list the
actual dates for the holidays.

Lets assume 1/1/2009 and 1/2/2009 are holidays. List those dates in a
range
of cells:

J1 = 1/1/2009
J2 = 1/2/2009

Then you refer to that range like this:

=WORKDAY(A1,11,J1:J2)
....