Aug 16 2022 11:59 PM
Good day,
I'm using project desktop. I used the the date diff formula to calculate the days left from now until the finish date of a task, but I want to know is there a way to use this formula or any other method to calculate/show the amount of days between 2 specific tasks. They are not direct predecessors.
Thanks in advance
Aug 17 2022 07:54 AM
Aug 17 2022 07:56 AM
Aug 21 2022 06:34 AM - edited Aug 21 2022 06:38 AM
I can offer the following "impractical" approach. Suppose that you need to constantly watch the days between T1's finish and T3's start.
Flag1 renamed as Mark_Finish, Flag2 renamed as Mark_Start
Finish1's formula: iif( [Flag1], [Finish], ProjDateValue("NA"))
Select "Rollup: Maximum" for summary rows
Start1's formula: iif( [Flag2], [Start], ProjDateValue("NA"))
Select "Rollup: Maximum" for summary rows
Number1's formula: iif( [ID] = 0, ProjDateDiff( [Finish1], [Start1] ) / [Minutes Per Day], 0)
Select "Use Formula" for summary rows
And this is the result:
You can hide the columns for Finish1 and Start1, after having done with testing.