What can we help you with?

e.g. Gantt chart, Creating tasks, Sharing folders

Blog

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

2 comments

  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    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.

    Hugh Community Team at Wrike ๐ŸŒŽDiscover... Wrike Discover and become a Wrike expert. Click here to get started

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! ๐Ÿ‘ Innovative Approach ๐Ÿ’ก Stellar Advice ๐Ÿ’ช
    Avatar
    Olivia

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

    ย 

    Best,ย 
    Olivia

    Is this helpful? 0
    Comment actions Permalink

Please sign in to leave a comment.

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]

Community

Welcome ๐Ÿ––

Hi there! ๐Ÿ™‚ Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome ๐Ÿ–– Have you checked out this week's Release Notes yet?

Hey! ๐Ÿ‘‹ Curious about something? Visit How To to search and ask the Community for answers.

Welcome! ๐Ÿ‘‹ Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.