How to Calculate TAT

[R6R]

Hi Leads,

How to calculate the TAT between received date and closed date excluding the weekends and holidays. Please help me on this.

[R6R]

Thank you I am getting the TAT excluding the Weekends, however could you please help me how to include the holidays in to this, I have the sample data set, but unable to upload here, hence pasting it below. I have to consider weekends and holidays which are 01/01/2021 and 1/26/2021. 

Ticket#	Recived Date	Customer Name	Closed Date	Closed By
123	01-01-2021	Ajith	03-01-2021	Rajesh
234	02-01-2021	Rajith	04-01-2021	Rajesh
345	03-01-2021	Santhosh	05-01-2021	Rajesh
456	04-01-2021	Jovan	06-01-2021	Rajesh
567	05-01-2021	Visin	07-01-2021	Rajesh
678	06-01-2021	More	08-01-2021	Rajesh
789	07-01-2021	Atul	09-01-2021	Rajesh
900	08-01-2021	Vysakh	10-01-2021	Rajesh
1011	09-01-2021	Sayal	11-01-2021	Rajesh
1122	10-01-2021	Sunil	13-01-2021	Rajesh
1233	11-01-2021	Divya	14-01-2021	Rajesh
1344	12-01-2021	Veena	15-01-2021	Rajesh
1455	13-01-2021	Raji	16-01-2021	Rajesh
1566	14-01-2021	Saji	17-01-2021	Rajesh
1677	15-01-2021	Adith	18-01-2021	Rajesh
1788	16-01-2021	Diya	19-01-2021	Rajesh
1899	17-01-2021	Rohan	21-01-2021	Rajesh
2010	18-01-2021	Ajith	22-01-2021	Rajesh
2121	19-01-2021	Rajith	23-01-2021	Rajesh
2232	20-01-2021	Santhosh	24-01-2021	Rajesh
2343	21-01-2021	Jovan	25-01-2021	Rajesh
2454	22-01-2021	Visin	26-01-2021	Rajesh
2565	23-01-2021	More	27-01-2021	Rajesh
2676	24-01-2021	Atul	28-01-2021	Rajesh
2787	25-01-2021	Vysakh	29-01-2021	Rajesh
2898	26-01-2021	Sayal	30-01-2021	Rajesh
3009	27-01-2021	Sunil	29-01-2021	Rajesh
3120	28-01-2021	Divya	30-01-2021	Rajesh
3231	29-01-2021	Veena	31-01-2021	Rajesh
3342	30-01-2021	Raji	01-02-2021	Rajesh
3453	31-01-2021	Saji	02-02-2021	Rajesh
3564	01-02-2021	Adith	03-02-2021	Rajesh
3675	02-02-2021	Diya	04-02-2021	Rajesh
3786	03-02-2021	Rohan	05-02-2021	Rajesh
3897	04-02-2021	Ajith	06-02-2021	Rajesh
4008	05-02-2021	Rajith	07-02-2021	Rajesh
4119	06-02-2021	Santhosh	08-02-2021	Rajesh
4230	07-02-2021	Jovan	09-02-2021	Rajesh
4341	08-02-2021	Visin	10-02-2021	Rajesh
4452	09-02-2021	More	11-02-2021	Rajesh
4563	10-02-2021	Atul	12-02-2021	Rajesh
4674	11-02-2021	Vysakh	13-02-2021	Rajesh
4785	12-02-2021	Sayal	14-02-2021	Rajesh
4896	13-02-2021	Sunil	15-02-2021	Rajesh
5007	14-02-2021	Divya	16-02-2021	Rajesh
5118	15-02-2021	Veena	17-02-2021	Rajesh
5229	16-02-2021	Raji	18-02-2021	Rajesh
5340	17-02-2021	Saji	19-02-2021	Rajesh
5451	18-02-2021	Adith	20-02-2021	Rajesh

[amitchandak]

@R6R 

A new column like

Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR(Table[received Date],Table[closed Date]),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))

Refer

How to calculate Business Days/ Workdays, with or without date table: https://youtu.be/Qv4wT8_P-AA