DATE + 15 CAN NOT END ON WEEKEND OR HOLIDAY

[RMART]

I am trying to calculate a due date that is 15 days in the future. If the 15th day is a weekend or holiday (Xmas or New Years) I need the due date to be the next available weekday.

 

[IML]

See the Workday function (requires that analyst tool pak be installed). this does exactly what you want.

 

[IML]

Just checking some old postings and I think I may have steered you wrong here. Workday is still your function, but I orignally had a formula such as

=WORKDAY(A1,15,myholidays)

in mind, where myholidays is a named range containing your holidays.
This will add 15 non-weekend non-holidays to your date in A1. But sounds like you want to count 15 days (weekend, holiday, or not) and just not land on a weekend or holiday.
I believe

=WORKDAY(A1+14,1,myholidays)

would get you there.

Good luck