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!
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!
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.
Jeffrey Bond Do you have any sub-projects that it might be counting?
These are all stand alone projects, no subs
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?
We are using a standard field "Due Date" and the "Now" function but it just doesn't work as expected.
Same issue for me.