4 Replies Latest reply: May 20, 2015 7:13 AM by Amit Saini RSS

    Calculation based on Business days only help!

    Amit Saini

      Hi Folks ,

       

      Below is my calculated expression for Ticket Age :

       

      =if(IsNull(if(%ClosedDate < 2958465, date(%ClosedDate))),floor(today()-(date(%OpenedDate))),floor((if(%ClosedDate < 2958465, date(%ClosedDate)))-(date(%OpenedDate))))

       

       

      Now my requirement is not to include Sat, Sun in this calculation , want Ticket Age based on only 5 working days.

       

      Kindly suggest!

       

      Thanks,
      AS