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

expressions
(VICTOR VERA) #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???

(Aleksi Alkio) #2

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

(VICTOR VERA) #3

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

(VICTOR VERA) #4

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