Column with Remaining Days

Can a column be added that can display the remaining days of a task ? and How can be this done.

Thanks

Find more posts tagged with

Construction

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())

Craig

thank you very much craig.. You are a live saver