8 Replies Latest reply: Nov 17, 2016 1:51 AM by Dipesh Vadgama RSS

    Workdays ??

    Dipesh Vadgama

      Hi All,

       

      I have a date & number_of_days. I want a output Date+Number_of_days = Actual Date (Excluding Saturday & Sunday)

       

      Excel have a formula called Workday, but I not able to calculate in Qlik sense.

       

      Eg.

         

      DateNo. DaysActual Date
      12-Oct-16-111-Oct-16
      12-Oct-16-111-Oct-16
      17-Oct-16219-Oct-16
      18-Apr-16-511-Apr-16
      7-Apr-16-34-Apr-16
      6-Apr-16-431-Mar-16
      22-Jun-16123-Jun-16
      19-Jan-16425-Jan-16
      10-Feb-16-35-Feb-16