Datediff Excluding Weekend

Marc Joseph Villagracia

Hi Team, 

 

So i was trying to find ways to calculate start and end dates and exclude sat sun but I can't seem to find a working solution. 

So for my flow, I use

{{issue.Start date.diff(issue.End date).days.abs.plus(1)}}

 

So far, this gives me the result that i want as long as weekend is not involved but I want to exclude weekend, has anyone implemented something like this in the past? 

Walter Buggenhout

Hi @Marc Joseph Villagracia,

Instead of days you can use businessDays as unit, thus excluding weekends. So:

{{issue.Start date.diff(issue.End date).businessDays.abs.plus(1)}} 

Hope this helps!