Determine days overdue

anne.fogarty

I would like to have a column showing how many days overdue a task is using a due date column and a check box that indicates if the task is complete or incomplete.

I have tried the COUNTIF function but don't know if this works with a check box. See my columns below.

Nic Larsen

Try something like this:

=IF(AND([Task Complete]@row = 0, [Leads Due Date]@row < TODAY()), [Leads Due Date]@row - TODAY())

Not knowing your task column name, you'd need to replace the one in mine.