I am trying to omit weekends and holidays from my timeline calculations, but I my formula is still counting the weekends for some reason. Any help would be greatly appreciated:


=IF(WEEKDAY(G21)=7,WORKDAY(G21,1,E31:E40),IF(WEEKDAY(G21)=1,WORKDAY(G21,1,E31:E40),WORKDAY(G21-1,1,E31:E40)))

(My holidays are listed between E31:E40)



Thank you in advance