Add option in datediff function to exclude weekends when counting days

I use this approach and wanted to share in case it is helpful to you too.

Until the formula is changed you could try this approach. There are some limitations if you start or finish on a weekend you may be out by 1 day, for me it was close enough.

datediff(field("Feature start date"),field("Feature end date"),"day")-(datediff(field("Feature start date"),field("Feature end date"),"week")* 2)

I will break it down:

Step 1 - Total days

datediff(field("Feature start date"),field("Feature end date"),"day")

Step 2 - Calculate the number of weeks

datediff(field("Feature start date"),field("Feature end date"),"week")

Step 3 - Calculate weekend days

datediff(field("Feature start date"),field("Feature end date"),"week")*2

If you put it all together you get this:

working days = Total days - (total weeks x 2 days)

If you look at the last example it starts on a Sunday and if you include that day then there should be 9 weekend days not 8 so it's out by 1 day. So it's not 100% perfect but it's pretty close.

Needed if you are running KPI's - a few days make a big difference.

It is so basic... How the heck disconsider weekends as a standard?

as others have said, excluding weekends will help build a more accurate picture of lead times/time to deliver on features etc. there is an existing, similar excel function (workday) that already does this.

This was requested today by our idea intake manager who reports lead time metrics. We are using the datediff formula and would like to show the result in working days only.

datediff(field("Feature start date"),field("Feature due date"),"weekday")

Ideally the UX would be something like this.

Calculating only Network days gives an accurate representation of the Utilization %.