Hello Community, I need to calculate the numb...

AppSheet AppSheet Q&A
1

Hello Community, I need to calculate the number of DAYS between 2 dates in 2 columns [Actual Start Date] and [Actual End Date]

It returns DURATION but i need the number of days not the duration, I will use this calculation as part of an action that inputs the result in a “Duration in days” column but it wont accept the expression because the “Duration in days” column is a number column not a duration column

any Ideas???

2

You need to convert the duration as days like HOUR([Actual End Date] - [Actual Start Date])/24.

3

Awsome, now how do I get the result to ignor counting saturday and sunday???

4

Awsome, now how do I get the result to ignor counting saturday and sunday???@Aleksi_Alkio