Hello everyone,
New to appsheet here.
I have two columns, [Start Date] and [End Date].
I am using a virtual column called [Days] and i want to know how to calculate using the Hour([Start Date]-[End Date]) / 24 method but to exclude weekends (Saturday and Sunday).
I prefer to use the networkdays directly from Spreadsheet as i am using Appsheet Database. Is there any possible way to do it? Duration may go beyond 30 days if i may add.
Thank you.
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |