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???
You need to convert the duration as days like HOUR([Actual End Date] - [Actual Start Date])/24.
Awsome, now how do I get the result to ignor counting saturday and sunday???
Awsome, now how do I get the result to ignor counting saturday and sunday???@Aleksi_Alkio
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |