1 Reply Latest reply on Jun 20, 2019 7:01 AM by Norbert Maijoor

    How to Calculate TAT excluding Saturday, Sunday and Holiday

    Pankaj Singh

      Hi,

       

      Need your help on below mentioned query.

       

      Currently i am using below mentioned Calculated field to get TAT (Excluding Weekend ) which is working file. But i also want to exclude the Holidays.

       

       

      IF [Description] = 'Creation Date' THEN

       

      TODAY()-DATE([Reopen Time]) - ((ceiling(max(0,datetrunc('week',TODAY(),"Sunday")+1 -datetrunc('week',DATE([Reopen Time])+6,"Sunday"))/7))

      +

      (ceiling(max(0,datetrunc('week',TODAY(),"Saturday")+1- datetrunc('week',DATE([Reopen Time])+6,"Saturday"))/7)) )

       

      If suppose i need to exclude 22/06/2019 and 25/06/2019 as holiday, then how i will arrive on this.

       

      Thanks

      Pankaj