View Single Post
  #1   Report Post  
Aviator
 
Posts: n/a
Default Skip the holidays

Is there a way to skip the holidays in this formular:

=IF(E$23="","",IF(WEEKDAY(E$23+1,2)5,E$23+1+(WEEK DAY(E$23+1)2)*7-WEEKDAY(E$23+1)+2,E$23+1))

I have the days set up automatically but with this formula, the holidays are
still in.

Thank you,

Aviator