Calculate how many working days are there between two dates

[LyleLin]

I've created a leave application system. When employees apply for leave, they fill out the start date and end date of their leave. I want the program to automatically calculate the total number of working days for the leave application. For example, if the start date is Friday, 11/29, and the end date is Monday, 12/9, although there are 11 days in between, the actual working days are only 7. How can I write a formula to make the program calculate 7 working days? Thanks.

[Steve]

WORKDAY()

[LyleLin0626]

Sorry, but it seems this cannot achieve the result I was hoping for. workday() can Returns the date computed by adjusting the date by the number of workdays. But what I want to know is how many working days are there between the two dates.

[TeeSee1]

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Workdays-between-2-dates/m-p/369877#M138256