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

[VICTOR_VERA]

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]

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

[VICTOR_VERA]

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

[VICTOR_VERA]

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