OVERDUE Formula

Molly12345

Hi I would like to say:

if the completed date is greater than the end date put "overdue" in the column

If completed date is empty and it is after the end date put "overdue"

If the end date is empty leave empty

This is not working

=IF(OR(AND(ISBLANK([Completed Date]@row), TODAY() > [END]@row), [Completed Date]@row > [END]@row), "OVERDUE", " ") + IF(AND([END]@row <>, ""))

And this works on some of my sheets but randomly leaves OVERDUE on three rows that are empty. yet the rows below it are also empty and they are not OVERDUE

=IF(OR(AND(ISBLANK([Completed Date]@row), TODAY() > [RQ END]@row), [Completed Date]@row > [END]@row), "OVERDUE", " ") + IF([END]@row = "", "")

Any help would be greatly appreciated! Thanks in advance

Paul Newcome

Try this:

=IF([End Date]@row <> "", IF(IF([Completed Date]@row <> "", [Completed Date]@row, TODAY()) > [End Date]@row, "Overdue"))

Molly12345

Fantastic!Thanks so much for your response Paul. I am learning through your comments!

I now need to exclude if "Not Due" in the Execution Completed" column. I have been trying different variations but am going wrong somewhere here =IF([RQ END]@row <> "", IF([Execution Completed]@row "Not Due", "") IF(IF([Completed Date]@row <> "", [Completed Date]@row, TODAY()) > [RQ END]@row, "Overdue"))]

Thanks in advance 🙂

Paul Newcome

If I understand correctly, this should work for you:

=IF(AND([End Date]@row <> "", [Execution Completed]@row <> "Not Due"), IF(IF([Completed Date]@row <> "", [Completed Date]@row, TODAY()) > [End Date]@row, "Overdue"))