Column with Remaining Days

Edgar Montalvo · 03/11/16

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

Thanks

J. Craig Williams · 03/11/16

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

Edgar Montalvo · 03/14/16

Thank you very much craig,,

Best regards

Edgar Montalvo · 03/14/16

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

J. Craig Williams · 03/14/16

=IF([Due Date]23 - TODAY()<0,0,[Due Date]23 - TODAY())

Craig

Edgar Montalvo · 03/14/16

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

Comments