Analyze formula to calculate working days left in a project

Hi Team!

I have spent way too much time digging through community, google and have not been able to crack the code.

A valuable tool for us it to calculate how many working days are left in a project, this has a few key values but most importantly it is a quick way to identify talking points for our planning meetings as well as calculating future "booked" effort.

We have tried multiple DDIFF formulas and always get crazy numbers, anyone have the secret code?

Summary of data points

Project Due Date, Today to find remaining working days.

Thanks!

Find more posts tagged with

Comments

Aman Prabhakar

Hi Jefferey,

You can use the below-mentioned formula

To calculate the number of days left for the Projects: DDIFF(Days in Project due date, NOW(Days in Project Due date)).

To calculate the number of days left for the Tasks: DDIFF(Days in Task due date, NOW(Days in Task Due date)).

When selecting the Project due date as the argument in the formula, it defaults to "Years in Project due date." You then need to right-click and choose the "Group by" option to change it from Years to Days. Output: You may receive positive or negative values for days; positive values indicate that the 'x' number of days remain, while negative values show that the project/task is overdue.

Thanks!

Jeffrey Bond

One would think that would work but check this out

Date this was run as 3/13/25 and it the value it shows for the Amp'd Up project is 560, but should be 140 at most, the 140 is actually calendar days, work days , which is what I am after, should be 96 days. Formula Used is DDiff([Days in Project Due Date],NOW([Days in Project Due Date])), grouped by days.

Therese Forsyth

@Jeffrey Bond Do you have any sub-projects that it might be counting?

Jeffrey Bond

These are all stand alone projects, no subs

Cindy Munoz

Hi All, where can I find the fields used in this formula? I don't seem to have these on my formula list. Are these custom fields?

Jeffrey Bond

We are using a standard field "Due Date" and the "Now" function but it just doesn't work as expected.

Francesco Pace

Same issue for me.

Herine Kniazian

Hi @Jeffrey Bond! Please try adding an aggregator to the DDIFF formula, for example MAX:
MAX(DDIFF(Days in Task due date, NOW(Days in Task Due date)))

Sometimes Wrike Analyze is being naughty and duplicating numeric values, I believe it might be happening with your formula too.

Therese Forsyth

Thank you @Herine Kniazian! I was attempting the DDIFF between project creation and start dates, and this solved it!

Alex Boot

Slightly different question on this, is it possible to see the duration of all tasks at a folder level in WA? I have this data at a project level but I'd like to dive deeper and see the folder durations of the earliest and latest tasks in a folder.

Herine Kniazian

Hi @Alex Boot, nice to meet you:) and I hope I'm not replying too late!
Absolutely yes! You just need to add Folder Name to your widget and then Task Duration as a formula. You might also need to define Include Data Depth Level to exclude subfolders or spaces:

Add Folder Name to Rows in a pivot widget
Add Task Duration to Values (the system will automatically use SUM function)
Either filter Folder Name, or add Include Data From Depth Level to exclude subfolders or parent folders.

However, please note that this will work only if you don't have any project-related info in the widget. If you want to see both projects and folders in the same widget, please feel free to refer to this article: /hc/en-us/community/posts/15967236937367--From-Wrike-Folders-and-Projects-in-Wrike-Analyze-Hierarchical-Structure?_gl=1*11xi576*_up*MQ..*_ga*NTc1Mjg4MjE1LjE3NTQ5NDE4NTc.*_ga_T1BT53T67Q*czE3NTQ5NDE4NTckbzEkZzEkdDE3NTQ5NDE4ODQkajMzJGwwJGgw

Tamer Akkartal

As I understood that Jeffrey Bond's question wasn't answered, I have the same issue. The formula that I used is MAX(DDIFF([Days in Task Status Change History Change Date],[Days in Task Status Change History Previous Change Date])). It brings 20 days, including weekends. I'd like to have only work days. Is there anyone who can help me solve this? @Herine Kniazian Maybe you can help :)