How to calculate difference using single date field

[sirivis24s]

Hi All,

I am New to QlikView  I have data like

Change date	changer		Old assigned to	New Assigned to	Old status	New Status	Name	DTAT
11/1/2020	Sujan			Darrielle		New	-	-
11/4/2020	Darrielle		Darrielle	Sujan	New	Need More info	Darrielle	3
11/4/2020	Sujan		Sujan	Darrielle	Need More info	Open	Sujan	1
11/4/2020	Darrielle		Darrielle	Dhruv	Open	Open	Darrielle	1
11/12/2020	Dhruv		Dhruv	Dhruv	Open	Fixed	Dhruv	7
11/15/2020	Dhruv		Dhruv	Sujan	Fixed	Ready to retest	Dhruv	2
11/21/2020	Sujan		Sujan		Ready to retest	Closed	Sujan	5

I need to Calculate  no of days between dates for eg

changed date is 11/1/2020 to 11/4/2020  then DTAT is 3 excluding Saturday's and Sundays .below is criteria 

Thanks

Sujan.s

[Taoufiq_Zarra]

@sirivis24s  I used from the Excel file this expression:

SampleData:

load *,networkdays(Date(peek(AU_DATE)),Date(AU_DATE)) as DTAT;

LOAD AU_ENTITY_ID, 
     AU_USER, 
     AU_DATE, 
     AP_OLD_VALUE, 
     AP_NEW_VALUE//, 
    // DTAT
FROM
.\Defects_History.xls
(biff, embedded labels, table is Sheet1$);

and this is the output :

Make sure that :

SET DateFormat='M/D/YYYY';

[sirivis24s]

Hello Taoufiq,

I have tried it but notworking  can you try this excel in your machine