dates

[Alessandro Correlli]

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

[#2]

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.

[#3]

Hello,

Indeed, I did a mistake

Thanks for your help ;)

Kr