DDIFF between due dates on two tasks

Hi there Kate Brozda !

I asked a similar question in regards to due dates. This was the formula someone sent me and it worked great. It's not exactly what you're doing, but I think the concept is the same or similar. You can read the other thread here. I hope it helps you!

SUM([Task ID], if (SUM(ddiff([Days in Task Completion Date], [Days in Task Due Date]))<01,1,0))

Hi Kate Brozda,
This is (surprisingly?) difficult to do. You'll need do two separate comparisons and then combine them together. It will probably look something like this:

(MAX(DDIFF(NOW([Days in Task Due Date]), [Days in Task Due Date])), [VM Kickoff (Task Name?)])
- (MAX(DDIFF(NOW([Days in Task Due Date]), [Days in Task Due Date])), [VM Site Demo (Task Name?)])

What this formula does is compares Today's date (the NOW function) to the Due Date of the VM Kickoff task, and then subtracts that value from the comparison of Today's date to the VM Site Demo task.

For an example. Lets say today is the 1st, tomorrow is the VM Kickoff (the 2nd), and then the Site Demo is the 4th. The calculations would be the first DDIFF (-1) minus the second DDIFF (-3). (-1) - (-3) is 2, which is correct. Try it with other dates on a piece of paper, the math checks out.

The only thing is that you need someway to filter the first and second functions to ensure your DDIFF is only getting the one task you want in each expression. For this, we make use of the FILTER function, that looks like this:

(<Value>, <Filter 1>, (<Filter 2>),...)

Where the first item is the value to calculate, and the second (or more) item is the filter you want to use. You'll see in my original formula, I have a filter after the DDIFF expression where I input the VM Kickoff Task Title. This works if every Kickoff task has the exact same title. If they don't have the same title, I'd recommend creating a Custom Field that you can put on every Kickoff task to properly identify it for reporting purposes, and then use that field as your filter.

I know that was a lot, please let me know if you have any more questions!

Mark Tapia Community Team at Wrike Wrike Product Manager Conosci le straordinarie funzionalità di Wrike e le best practices

Mark Tapia Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices

Hi Mark! Could you help me with this formula: sum([Project ID],if(and(min(ddiff([Days in Project Start Date].[Days in Project Creation Date])=>15,1,0)),(Max(ddiff([Days in Project Start Date],[Days in Project Creation Date]))<25,1,0)) : basically I want to be able to filter when Days in Project Start Date-Days in Project Creation Date is between 15 and 25...

Hi Gaelle Sannia,

Herine from Wrike Team is coming to the rescue!

The easiest way to filter the output is applying a widget filter to the formula. The formula can be just:

 DDIFF([Days in Project Start Date],[Days in Project Creation Date])

You can also aggregate it by MIN, AVG, MEDIAN, or MAX to make sure there's no conflict with week dimensions, checkboxes, etc.:

MAX(DDIFF([Days in Project Start Date],[Days in Project Creation Date]))

Then you need to filter the formula by 2 conditions with the operator AND:

As result, only the projects with the start date in 15-25 days after the creation date will be displayed in the widget.

I hope this helps!

Herine Community Team at Wrike Wrike Product Manager Conosci le straordinarie funzionalità di Wrike e le best practices

Herine Wrike Team member Conosci le straordinarie funzionalità di Wrike e le best practices