Help with a Date Formula

  • Thread starter LoveBuildingHouses
  • Start date
L

LoveBuildingHouses

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 are:
11-24, 11-25, 12-22, 12-23, 12-29, 12-30

Thanks for your help! Trista
 
R

Robbo

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.
 
L

LoveBuildingHouses

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