2 Replies Latest reply: May 11, 2018 4:19 PM by Shivanand Kamath RSS

    Find No of working days excluding sat sun and holiday list?

    shruti thakur

      Hi ,

       

      Please help in calculating no. of days in  the below data file.

       

          

      [Issue key]CreatedCreated_DateCreated_today(today()-Created_Date)+1
      GEMPRODSUP-427504/May/18 2:07 PM04/05/201811/05/20188
      GEMPRODSUP-427904/May/18 4:43 PM04/05/201811/05/20188
      GEMPRODSUP-423403/May/18 9:52 AM03/05/201811/05/20189
      GEMPRODSUP-423503/May/18 9:57 AM03/05/201811/05/20189
      GEMPRODSUP-423603/May/18 9:59 AM03/05/201811/05/20189
      GEMPRODSUP-397626/Apr/18 7:24 PM26/04/201811/05/201816
      GEMPRODSUP-397726/Apr/18 7:59 PM26/04/201811/05/201816
      GPS-273426/Apr/18 2:31 PM26/04/201811/05/201816
      GEMPRODSUP-386425/Apr/18 9:34 AM25/04/201811/05/201817
      GEMPRODSUP-386525/Apr/18 9:51 AM25/04/201811/05/201817
      GEMPRODSUP-386625/Apr/18 10:26 AM25/04/201811/05/201817
      GEMPRODSUP-438009/May/18 5:21 PM09/05/201811/05/20183
      GEMPRODSUP-438209/May/18 6:07 PM09/05/201811/05/20183
      GEMPRODSUP-433308/May/18 8:32 AM08/05/201811/05/20184

       

       

      Thanks and regards,

       

      Shruti Thakur