Formula for showing difference between the earliest custom date entered in a task for a project and the oldest custom date entered

When we have a new market to add or have to remove an existing market, we create a new project for that market.  Within that project, we will have multiple custom tasks for different aspects of the market, and as part of that task is a custom date field for "Speed to Market"

So for example:

Project A:

Task 1 - Speed to Market = 10/22/2025

Task 2 - Speed to Market = 10/1/2025

Task 3 - Speed to Market = 10/15/2025

I am trying to create a formula that will take the earliest speed to market (by project) and get the date difference with the latest speed to market. So in this case, for project A the difference would be 10/22 - 10/1 = 21 days.  

Any help on figuring out this formula would be great. I know there is already an issue with excluding weekends/holidays but want to start trying to work on this portion before resorting to external reporting methods. 

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

Hi Scott Czajkowski, it appears no community solution has been suggested here yet. Were you able to find a workaround, or would you like to get in touch with our Support team for help?

Basudha Sakshyarika Community Team at Wrike Wrike Product Manager Conviértete en un experto de Wrike con Wrike Discover

Basudha Sakshyarika Wrike Team member Conviértete en un experto de Wrike con Wrike Discover

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

Folllowing List for Post: Formula for showing difference between the earliest custom date entered in a task for a project and the oldest custom date entered
[this list is visible for admins and agents only]

Superior

Próximas sesiones en vivo

¿No encontraste lo que buscabas? Escribir nueva publicación