Formula specific to date in the past, on time, late or overdue

Platform discussions
,
1

Hi Monday Brains Trust,

Hoping someone can assist me. I’ve searched some of the discussions and come across a formula that works great with just one missing item. I’d like to add an IF statement that checks if the Due Date is in the past and Actual Date is blank (meaning not completed) and returns a value of “Overdue”.

Here is what I have so far that is working
IF(
OR(
{Date Completed}=“”,
{Due Date}=“”
),
“”,
IF(
FORMAT_DATE({Date Completed},“YYYY-MM-DD”)<FORMAT_DATE({Due Date},“YYYY-MM-DD”),
“On Time”,
IF(
FORMAT_DATE({Date Completed},“YYYY-MM-DD”)>FORMAT_DATE({Due Date},“YYYY-MM-DD”),
“Late”,
IF(
FORMAT_DATE({Date Completed},“YYYY-MM-DD”)=FORMAT_DATE({Due Date},“YYYY-MM-DD”),
“On Time”,
“”
)
)
)
)