1 Reply Latest reply on Apr 9, 2018 12:59 AM by Sankarmagesh Rajan

    How to exclude Saturday and Sunday while calculating the TAT

    ganesh kamath

      Hello Peeps,

       

      I got stuck in a problem and I'm seeking advice from you.

       

      I have a start date and end date and interested to calculate the TAT for the same. But I want to exclude the "Saturday " and "Sunday", since it's a weekly off.

       

      I have tried to do it, but getting different output for each cases.

       

      Request you to kindly advice, how can I get the TAT by excluding the Saturday and Sunday.

       

      Also it will be very grateful, if you advice me how to exclude the public holidays too!!!!

       

      Thanks in advance!!!

       

      Regards,

      Ganesh R Kamath