Have you tried using the 'WORKDAY' function? This allows you to enter
holidays into the calculation.

If it isn't available in your function list, go to Tools, Add-Ins, and then
click the analysis toolpak option. This gives you some more functions.

"LoveBuildingHouses" wrote:

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