Can anyone recommend the best formula to calculate overdue tasks?

Latisha Miller

Currently using- =COUNTIFS(AND({SS Project Plan Completion Date Range}, NOT([{SS Project Plan Status Range} = "Complete")]) < TODAY())

I want to exclude completed task from the count. Currently returning UNPARSEABLE error

Jana Brits

Hey

Perhaps it might be because your first Logic Expression after AND is incomplete. What should the {SS Project Plan Completion Date Range} be?

Hope it helps,

Regards,