Column view that shows task cumulative days in a project | Community
Skip to main content
MattEl5
MattEl5
Level 3
February 10, 2025
Solved

Column view that shows task cumulative days in a project

  • February 10, 2025
  • 1 reply
  • 1240 views

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! 

Best answer by 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!! 


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!!! 

1 reply

JustinRenteria2
JustinRenteria2
Level 6
February 11, 2025

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
    MattEl5Author
    Level 3
    February 11, 2025

    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
    JustinRenteria2
    Level 6
    February 11, 2025

    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. 

      Terms & ConditionsAccessibility statement

      Loading footer...