Calculate the difference between two task dates

Hello, 

Is there a way to write a function that will calculate the days between the latest "Post Event - XYZ" task and "Preplanning" task?  There can be one or up to several "Post Event - XYZ" tasks per project. 

In the example below, the calculation should be "Post Event - Social Media" 4/11/2025 minus "Preplanning" 9/9/2024 which equals 214 days. So, the calculation should ignore "Post Event - Company Intranet." 

Thank you

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

Hi JP,

if you insert all task in a parent task and turn on automatic calculation for dates:


Then in duration you will see how many days you have between first and last date task

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

Folllowing List for Post: Calculate the difference between two task dates
[this list is visible for admins and agents only]

Haut de la page
Didn’t find what you were looking for? Write new post