7 Replies Latest reply: Nov 8, 2017 4:42 AM by Grzegorz Smajdor RSS

    Add Working Days to a date

    Grzegorz Smajdor

      Hi,

       

      Is there any function to add working days?

      The function should do the same as Excel function Workday(date, workingDaysToAdd)

       

      I tried lastworkdate() function, but the function doesn't return the same results as Excel Workday()

         

      qlik: lastworkdate(date, 5)

      excel: workday(date, 5)

       

      date       qlik            excel
      25-Mar-1731-Mar-1731-Mar-17
      26-Mar-1731-Mar-1731-Mar-17
      27-Mar-1731-Mar-173-Apr-17