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
Bookmarks