Oct 15 2018 01:50 PM
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 November 2018) and the week-end, E83 + 26 working days = Friday 07/11/18. But due to the fact that the opr reception is not done at that day, it's shifted to the tuesday 11/12/2018.
Other ex :
if E83 + 26 working days = Wednesday --> to be shifted on thursday - Wednesday 17/10/18, the opr reception will be the 18/10/18
if E83 + 26 workind days = Friday --> to be shifted on monday next week - Tuesday 23/10/18 instead of friday 19/10/18
Thanks in advance
Oct 15 2018 02:49 PM
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.