Days Difference between 2 dates excluding Weekends (Sat & Sun)

[itsmeanuj]

Hi,

I have a huge dataset where I want to calculate the difference between 2 dates including only Business days (i.e. I just need to exclude weekends). Below is the sample data with the expected output. Data is in the DD-MM-YYYY Format.

First Date	Shipment Date	Difference (Expected Output
10-06-2020	12-06-2020	2
03-08-2020	07-08-2020	4
28-08-2020	28-08-2020	0
07-10-2021	13-10-2021	4
09-07-2020	09-07-2020	0
09-07-2020	16-07-2020	5

[Felipe_Ribeir0]

Hi @itsmeanuj 

One option that does not need to generate rows. Just formulas: