Column view that shows task cumulative days in a project

[MattEl5]

Hi folks. trying to make a column that works out the days a task finishes on from the start of a project and puts in a numerical value. 

So Project start date - 1/1
Task A > Due Date =  1/20

column says 19 days 

Bit of a rubbish explanation i know. but if theres any way to do this calculation it would really help!! thanks! 

[JustinRenteria2]

This will get you what you're looking for on a Task view column. 

displayname=Date Difference
linkedname=direct
valueexpression=DATEDIFF(CLEARTIME({plannedCompletionDate}), CLEARTIME({project}.{plannedStartDate}))
valueformat=HTML

[MattEl5]

Hi Justin! 

Thank you most kindly for this, its a great piece of text. 
Only issue i have is that its pulling calendar days, i was hoping to get business days. 

Maybe theres a calculation to put in,( to remove weekends) or a way of applying the schedule thats used for the project (which i think removes weekends and holidays)? 

thanks again this is very helpful nonetheless! 

[JustinRenteria2]

You can use the WEEKDAYDIFF function in place of the DATEDIFF function to the count of weekdays. I'm not sure if it'll take holiday's into account though. 

[JustinRenteria2]

Here's the Workfront documentation snippet detailing all the different functions in Workfront:
https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/...

[MattEl5]

displayname=Date Difference
linkedname=direct
valueexpression=WEEKDAYDIFF(CLEARTIME({plannedCompletionDate}), CLEARTIME({project}.{plannedStartDate}))
valueformat=HTML

Hey Justin, thanks for getting back so quickly! Holidays i can live without as long as i can get the weekday. 

Applied the above text, but its putting out minus figures now. Not sure if theres an order adjustment i need to make to right it? Thanks for all the help!! 

[MattEl5 · Accepted solution]

displayname=Date Difference
linkedname=direct
textmode=true
valueexpression=WEEKDAYDIFF(CLEARTIME({project}.{plannedStartDate}), CLEARTIME({plannedCompletionDate}))
valueformat=HTML

Flipped the 2 bits and its working!! THANK YOU JUSTIN!!!