8 Replies Latest reply: Aug 17, 2018 8:14 AM by Petter Skjolden RSS

    How to calculated Number of days

    Mahitha M

      Hi Experts,


      Can any one please help me to calculate below Days column from start date and end date by using below excel

      calculation in Qlik


      Days = DAYS360(Startdate,Endate)/30


      Startdate          Enddate              Days(Expected output)

      01/01/2018      31/03/2018           3.00

      01/04/2018     30/06/2018            2.97


      Thanks in advance