Wrike Analyze (Feature Request): Ability to calculate working days by excluding weekends and holidays
Hello!
While building some of our first Wrike Analyze reports, we've come across some features that we think are crucial to capturing accurate data and wanted to submit it here.
Problem: We need the ability to build a report that shows the number of business (working) days a set of project took to complete. While the DDIFF function allows us to calculate the difference between the date of creation and the date of completion of a project, it does not exclude weekends or holidays thus leaving the number higher than it should be.
Current workaround: While not accurate, we can multiply the formula DDiff([Days in Project Completion Date],[Days in Project Creation Date]) by (5/7) if the value is greater than 7 to get a closer number.
Ideas for solution:
- Determine if there is a way to add some filter functionality that could exclude weekends and exclude holidays set in your account work schedule within formulas.
- Our guess is that this number would be very important for multiple Wrike customers, so Wrike could simply add this to the Data Browser as a value part of the Project data. For instance, we have duration of tasks, but this could calculate the duration of the project based on the start date and due date of the project and exclude dates set in your work schedule as well as weekends.
I'm sure there are a few other solutions, but thought it best to list some.
Thank you!
Hi Mat Ward and Scott Czajkowski,
Apologies for the late reply 🙏🏼 I am raising a support ticket on your behalf to help you with your questions and any updates. Please feel free to share information in this thread, as it might be helpful for everyone. Thanks!
Basudha Sakshyarika Community Team at Wrike Wrike Product Manager Werden Sie ein Wrike-Experte mit Wrike Discover
Basudha Sakshyarika Wrike Team member Werden Sie ein Wrike-Experte mit Wrike Discover