3 Replies Latest reply on Dec 1, 2016 3:07 AM by Ashish Chaudhari

    No. of Days between two dates

    kumar k

      Hi,

       

      I was trying to calculate days difference between two dates but couldn't get result when there is weekend between those 2 dates.

      Highlighted the ones I am getting wrong output.

       

         

      Assigned DateCompleted  Date   Days   Taken (Actual)

      Days    Taken

      (Current)

      11/16/201611/17/201611
      11/16/201611/18/201624
      11/18/201611/21/201611
      11/9/201611/16/201668

       

      Note: Need to exclude Sat and Sun.

       

      Appreciate your help.

       

      Thanks,

      Kumar