8 Replies Latest reply: Mar 14, 2017 7:55 AM by Stefan Wühl RSS

    calculation error with Networkdays() function

    xavier Douchet

      Hello,

      I have a problem with the networkdays () function.

      This function takes into account holidays that are not within the calculation interval:

       

      for example:

       

      My date format is as follows:

      SET DateFormat = 'DD-MM-YY';

       

      The call of the function:

      Networkdays ('16 -01-17 ', '19 -01-17') referrals 4, between 16 and 19 January there are 4 working days: the result is correct.

       

      If now I set the {holiday} parameter by simulating a holiday on 20/01/2017 (so after the 19th)

      Networkdays ('16 -01-17 ', '19 -01-17', '20 -01-17 ',' 20-01-17 ') references 3.

       

       

      I have this problem every time my end date and the day before a holiday.

       

       

      Have you ever encountered this problem and what solution have you applied?

       

       

      Thank you for your help