How to count weekend days between two dates upon user's input

[Boyoung]

hi friends.

I want to know how many weekend days between two dates when user input two dates.

I want to calculate in app formula. 

Please let me help and give me your tips.

thanks for  your help.

[Suvrutt_Gurjar · Accepted solution]

Please take a look at the post below.

Solved: Workdays between 2 dates - Page 2 - Google Cloud Community

The discussion in the post is about workdays between two days. You can create an expression for the holidays based on

"Total Days between two dates- Workdays between two dates" .

In general, it is better to evaluate if you can use the spreadsheet's NETWORKDAYS() function ( as recommended by Marc Dillon in the post referred) because AppSheet expressions can become unwieldly for this requirement. Again by subtracting NETWORKDAYS() from total days between two dates, you could get weekend days.