Total number of days excluded weekends

[Jake15]

Hi Team,

Would like to check what is the issue of my expression below:

(HOUR([Leave End Date]-[Leave Start Date]) + (IF(WEEKDAY([Leave Start Date])<=5,0,IF(WEEKDAY([Leave End Date])<=WEEKDAY([Leave Start Date]),-2,-1))) * 24) / 24

I want to get the total number of leaves under the Total Leave Duration column (Number column type) but when I tried to leave for 5 days which is March 27 to 31, it shows a total of 4 only. See Screenshot below.

Not sure what I need to change in my expression. Thanks

[Marc_Dillon]

You can use the NETWORKDAYS() function in GSheets for this.