Okay I will try my best to not make this description a convoluted mess. My company has stopped disconnecting services on Fridays. Prior to the change the disconnection date was current date + 2 business days. While that still remains the same I now need to exclude Friday as well. Thus far I have come up with =IF(C52=6,WORKDAY(I30,3,holidays),WORKDAY(I30,2,holidays)).

** Where C52 is simply a reference to signify the day of the week and I30 is the current days date** Basically it is stating that if today is Wednesday make the disconnect date 3 business days and any other time make it two while accounting for holidays.

Well this actually works perfectly until you hit a holiday that lands on a Thursday, such as July 4th this year or Thanksgiving. On those days it pushes the date one day further than I need. To combat that I removed the holiday schedule for the "true" value and that solves the Thursday holiday problem but in return it doesn't work for Monday holidays.. After mulling over this and multiple face palms I am now surrendering and hoping that someone here can help me. Any help will be greatly appreciated and I thank you in advance for your time.