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 · Accepted solution]

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!

[Marc Joseph Villagracia]

thanks. it worked!

weird that when i used {{issue.Start date.diff(issue.End Date).businessDays.abs}} earlier, it didn't work.