Difference between 2 dates when it's fryday and monday

[Fred12]

Hello, 

I got a table  with a lot of date, for example :

TABLE 1 

ID                          DATE1                          DATE 2                             interval_day

1                          27/01/2023                  27/01/2023                      0

2                          27/01/2023                  30/01/2023                     3

3                        25/01/2023                 26/01/2023                        1

4                        26/01/2023                 27/01/2023                       1

My problem is about second line. I would like it put me 1,  because it counts saturday and sunday but I would like it didn't.

What I  would like is : 

TABLE 1 

ID                          DATE1                          DATE 2                             interval_day

1                          27/01/2023                  27/01/2023                      0

2                          27/01/2023                  30/01/2023                     1

3                        25/01/2023                 26/01/2023                        1

4                        26/01/2023                 27/01/2023                       1

Thanks for reading me 

[E_Røse · Accepted solution]

Try the networdays - function:

https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

Please like and mark my answer as a solution, if it resolved your issue.