I currently use this formula to create house building schedules:
=AD127+IF(WEEKDAY(AD127)=7,2,IF(WEEKDAY(AD127)=6, 3,1))

It only allows me to schedule weekdays; however, it doesnt account for
holidays. I would like to be able to set it up so that it will recognize the
6 remaining days that I consider to be holidays this year. I would like for
it skip to the next available weekday after that holiday. The holidays a
11-24, 11-25, 12-22, 12-23, 12-29, 12-30

Thanks for your help! Trista