Metadata menu formula to show relative date, "Today", "In 3 Days" etc

What I’m trying to do

I’m trying to show a relative date within my notes properties.

So for example if I have a “Due Date” property set as today’s date, a text property below shows “Today”.

I’d also like to achieve this for “In X days” or “X days overdue” etc.

I have the two properties “Due Date” and “Due”.

Due Date is set as a standard date property.
Due is set as a text property.

I’ve then linked Due to a new field setting in Metadata Menu with formula as the field type. Its just what formula to achieve this is where I’d stuck.

Things I have tried

I’ve tried adjusting some formulas i’m using for other solutions, but no joy. Dataview is not my strong point and I need some help on finding the correct way to do it. Any help would be greatly appreciate.