Try the WORKDAY replacement here. This works whether you want future dates or
past dates.

http://www.dicks-blog.com/archives/2...-addin-part-2/

If you want a slightly simpler formula where you have a list of all weekend
and holiday dates (P2:P1000) you could try this formula for future dates only

=SMALL(IF(ISNA(MATCH(ROW(INDIRECT("1:"&B2*10))+A2, P2:P1000,0)),ROW(INDIRECT("1:"&B2*10))+A2),B2)

confirmed with CTRL+SHIFT+ENTER

where A2 is start date and B2 number of workdays to add

note: assumes you will not have more than 9 sonsecutive holiday/weekend days





"George Ray" wrote:

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.