Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Can a column be added that can display the remaining days of a task ? and How can be this done.
Thanks
Edgar,
Assuming your due date column is named Due Date
=[Due Date]23 - TODAY()
in a Text/Number column will show the number of days from today for row 23.
Copy that to the rest of the column for the others.
Craig
Thank you very much craig,,
Best regards
Craig, it is possible that when you make the formula, that it does not display negative days. .
I mean that when the Due date is arrive, it stay on 0 days,, and when times passes, it does not start negative days. ?
Thank you
=IF([Due Date]23 - TODAY()<0,0,[Due Date]23 - TODAY())
thank you very much craig.. You are a live saver
