Excellent thread, very helpful.... thank you!
Now, how can I calculate a date that can land on any day of the week BUT will exclude holidays?

I tried using the NETWORKDAYS function (similar to how the WORKDAYS function was used above) but received #### which a pop-up Excel box indicates is "either an negative or too large to display." Any idea why this isn't working?