7 days from today - but not a weekend - next business day

[wtchtwr]

I have done tons of Microsoft Help / searches - I am stumped. I am calculating 8 calendar days from a date. The equation works, but if it falls on a weekend, I would like it to turn the date RED and show the first business day AFTER the weekend or holiday(I have all of the holidays entered for the NYSE for another cell.

But for the Calendar days I am using a "=B3+8." 1. What can be added to that so that it will not output a weekend or holiday. 2. What can be added so that if it fowards the date to the first business day it will highlight the number to notify the user that it has done so.

I am using the "=WORKDAY(B3,Sheet2!B1,Sheet2!A1:A18)" for the business days excluding weekends and NYSE holidays. That works flawless...

 

[DauntingGecko]

lookup the function "=day" :wink:

 

[wtchtwr]

lookup the function "=day" :wink:

HUH? That doesn't have anything to do with weekends...

 

[Oaktree]

Wouldn't it be =WORKDAY(date + 7,1,holidays) ?

Conditionally format the result as formula is =(current cell) <> date + 8 with a red font...

 

[orbea_adam]

Wouldn't it be =WORKDAY(date + 7,1,holidays) ?

Conditionally format the result as formula is =(current cell) <> date + 8 with a red font...

Oaktree is right. =WORKDAY() works great. But, I remember I had to install an Add-In to get it to work...

 

[wtchtwr]

Wouldn't it be =WORKDAY(date + 7,1,holidays) ?

Conditionally format the result as formula is =(current cell) <> date + 8 with a red font...

DING DING - We have a winner!!!

Seriously, Thank you for all of your help!!!