Forum Discussion
Alessandro Correlli
Oct 15, 2018Copper Contributor
dates
Hello, I have a new issue to solve. J83 = E83 + 26 working days. But the opr receptions (=J) are just done by the staff every tuesday and thursday. So, considering 2 holidays (1 & 2 Novem...
SergeiBaklan
Oct 15, 2018Diamond Contributor
Hi Alessandro,
That could be
=WORKDAY.INTL(WORKDAY.INTL(E83,26,1,$U$1:$U$2)-1,1,"1010111",$U$1:$U$2)
if in U1:U2 is list of holidays.
I only didn't catch your examples - 07 Nov 18 is not Friday, perhaps you mean 07 Dec 18, etc.