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
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