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