Help with a Date Formula
 

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

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

Thanks so much for your help! I figured it out and my formula is now ALOT
shorter. Have a great day!

"Robbo" wrote:

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