A function work-around
=start_date+SIGN(days)*SMALL(IF((WEEKDAY(start_dat e+SIGN(days)*(ROW(INDIRECT
("1:"&ABS(days)*10))))={2,3,4,5,6})*
ISNA(MATCH(start_date+SIGN(days)*(ROW(INDIRECT("1: "&ABS(days)*10))),holidays
,0)),ROW(INDIRECT("1:"&ABS(days)*10))),ABS(days))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"George Ray" <George
wrote in message
...
I am looking for an equivalent to the WORKDAY() function that does not
need
the analysis toolpak. I send a spreadsheet that uses it extensively, to
many
people, many of whom do not have the toolpak set up. I think there is an
equivalent that uses SUMPRODUCT(), but I cannot find it. I have a table of
holidays I can use, and I can set up a table of weekends if I need to.