add to start date and excluding days using workday not calculating right

Hi,

I trying to create a schedule that excludes holidays. I have been using =WORKDAY($H14+4,1,holiday!B2:B14). The problem is it is not calculating correctly it should be 1/2/2015 but returns 12/29/14. I know it is something that I'm doing any direction or advise would be greatly appreciated. I have attach a sample work sheet.

Thanks in advance,
Tom

It's the $H14+4 that's throwing you off.

What you want to do is put the number of days ahead in the second part of the formula:

Please Login or Register  to view this content.

This says "4 work days after $H14, excluding the holidays in B2:B14"

The formula you have currently is starting 4 calendar days after $H14, and going 1 workday after (excluding holidays).

Ahh, Is there anyway to make this dynamic so we are not hard coding the 4 days? So if we inputed a start date it would automatically pick up the holiday? Thanks for the help!!!

Just have that part of the formula reference a cell or value.

You had it hard-coded before as H14+4,1 but it needed to be H14,4 -- that's the only change needed for the WORKDAY formula to work. The rest depends on the data you put into it.