Formula to count days past due but leave the column blank if the task is completed

Sharayah Farrell

Hello,

On my sheet I have tasks that have a column for Due Date, Completion Date, and Checkbox for Done. I want to keep track of the tasks that are overdue and have an easy way to glance and see how many days they are over due from the due date. I have been successful in using this formula for that calculation

=TODAY() - [Due Date]@row

But using this it will calculate all my rows, even the ones that are completed. For now i've just used some conditional formatting to make the overdue ones red and the ones that are completed green, but i'd like to add to the formula to make it so that the ones that are marked complete don't put a number in the days past due column.

Formulas are not really my strongest area and i sort of just youtube and google my way through, but i am stumped on this one.

Thank you!

Mark Cronk

Try:

=IF(done@row=1, "", TODAY() - [Due Date]@row)

Change "done" to the name of your column if it's other than done.

Mark

Mark Cronk

Try:

=IF(done@row=1, "", TODAY() - [Due Date]@row)

Change "done" to the name of your column if it's other than done.

Mark

Sharayah Farrell

Mark, thank you so much that was exactly right!!!

SPRINGBOK