Meaninng if I have an activity that last 100 days how can i know which days we are at from the begin date to todays date?
One way to do this would be to have a Start Date column (using the Date data type) and a Days Since Start column (using the Column Formula data type), as shown here:
In this example, the Days Since Start column is a column formula that subtracts the Start Date column value from Today’s date, using the TODAY()
function, as shown here:
This column is also set to format the result as a Duration value with the days format, as shown here:
You could take this example further by enhancing the formula to show a percentage complete based on a predefined fixed number of days (e.g. “19% complete”), or returning a string displaying the number of days passed out of the total predefined number (e.g. “19/100 days passed”).
Great thanks!
This helped allot !
Can I ask another question?
What if I want a 2 tasks (or more) to be linked by start date?
meaning, I want to set the start date of task2 10 days after task 1, and if I change the start date of task1, then task 2 changes as well and accordingly?
Many thanks