Hi

You don't need the square brackets around hols.
=WORKDAY(H19, -10, hols)
--
Regards

Roger Govier


"bdehning" wrote in message
...
Great post but I am using the following and getting an error.

=WORKDAY(H19, -10, [hols]) and I have created range HOLS which are
all the
cells with the Holidays.

Fomula works fine without HOLS but when I add it I get the error.

Help Please.
--
Brian


"AdamV" wrote:

I think you just have a minor syntax / typo issue.

But, to clear things up before we go any further:
WORKDAY works out what date is X days after (minus = before) a given
start
date, ignoring wekends and optional holidays
NETWORKDAYS does the opposite - works out how many days are between
two
given dates, excluding weekends and hols.

So, it sounds like WORKDAY is what you need, but you want to go
backwards.
That's fine, but your arguments still need to be separated by a
comma, so you
want something like:
=WORKDAY(EndDate, -NumDays, [Hols])
NOTE the comma after EndDate - you can't do "EndDate-NumDays" or
there are
too few arguments (or rather the first holiday in your list would get
included as NumDays, and may well be out of range)

(apologies if your missed comma was a typo in the forum, rather than
in your
actual spreadsheet formula)

As mentioned above, watch out for whether you include or exclude the
end
date and modify accordingly (this depends on your business model,
there's no
'right' answer)

As an aside - make sure you use a named range to point at your list
of
holidays so you can easily modify to keep up with changes as you add
for
future years.
--
Adam Vero
MCP, MOS Master, MLSS, CWNA
http://veroblog.wordpress.com
http://www.meteorit.co.uk


"Fernbars" wrote:

I've been trying to develop a production schedule in Excel. I'd
like to put
an end date and have Excel calculate each activities' start date
based on the
number of days needed. I can do a simple subtraction formula (end
date-#of
days) however that does not take into account weekends and
holidays. I tried
the Workday function but that didn't work.

Suggestions are most appreciated. Thank you!