Forum Discussion
Datediff
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 o...
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.