Create a formula in Wrike Analyze for Task Duration (work days only)

Avatar
Olivia

Hello! 

I'm trying to create a formula (in Wrike Analyze) that calculates the duration of a task, but excludes weekends. Are there any formulas (or workarounds) that would allow me to do so?

 

Thanks, 
Olivia

 

DDiff([Days in Task Start Date], [Days in Task Completion Date])

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
2 comments
Avatar
Hugh

Hi Olivia!
 
Currently, there is no way to exclude weekends when calculating the duration of tasks in a formula. One possible workaround could be to use a CASE to specify that if the ddiff between the dates is >7, multiply by 5/7. This won't be precise, but it will give a duration that is more accurate than one including the weekends.
 
Hope this helps! If you need anything else, let me know.
1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Olivia

Thanks so much, Hugh, for this clever workaround! I will play around with it and see how it goes. :)

 

Best, 
Olivia

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Create a formula in Wrike Analyze for Task Duration (work days only)
[this list is visible for admins and agents only]

Top

Upcoming Live Sessions

Didn’t find what you were looking for? Write new post