I only know basic functions but what I'd like to do is have a column with the
date I need to have things done by, and then a column next to it with the
remaining days I have left to complete that task. I would like to have the
"remaining days" column where it is color coordinated so that it shows up
green when i have three days or more, yellow at two days, and red at 1 day or
less. I tried using the =now() function and then deleting that from the date
but it doesn't really show up right and the =networkdays() only shows up
amount of work days. And the real thing I can't do though is to filter the
days. I would like to be able to add something new that is due sooner and be
able to refilter the column so that most important (red 1 days) are at the
top and so on. I can't figure it out and need help bad. Thanks