Conditional Formatting based on System Date to capture current week

Content

Hello--

I'm creating a report where I need to define dates into buckets within the column.

I have Assigned Account, Due Date, Count of Ref.No. as my three columns.

My filters are in place to show due dates for current week and prior (including no values)- Removing any due dates out more than current week.

Within the Due Date column instead of showing the date:

If Due Date is less than the Sunday of current week= "Overdue"
If Due Date is current week= "Currently Due"
If Due Date is No Value= "No Due Date"

Can anyone assist?