RELATED IDEAS
Add option in datediff function to exclude weekends when counting days
The datediff function currently has the option to count the number of days between dates and this includes weekends.
Having an option to exclude weekends would help to count the weekdays, instead of including weekends.
-
-
-
-
-
-
-
-
-
-
-
-
- +2
© 2024 Aha! Labs Inc.•All rights reserved
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 %.