return text based off calender date

Anonymous, further to my first reply, I have created a solution which takes working days into account.

Create a Date dimension table which has a WorkingDays column as an integer. For working days set this to 1, for non-working days set it to 0. In my example I used this data for October:

Date   WorkingDays

Then in your data table, create a Calculated Column called WorkingDaysTillDueDate with this DAX expression:

WorkingDaysTillDueDate = 
    VAR duedate = YourTable[DueDate]
    VAR today = TODAY()
    RETURN
        SWITCH(TRUE(),
            duedate = today, 0,
            duedate < today,
            CALCULATE(
                0 - SUM(dimDate[WorkingDays]),
                dimDate[Date] >= duedate,
                dimDate[Date] < today
            ),
            duedate > today,
            CALCULATE(
                SUM(dimDate[WorkingDays]),
                dimDate[Date] > today,
                dimDate[Date] <= duedate
            )
        )

Now create another Calculated Column called DueStatus with this DAX expression:

DueStatus = 
    VAR days = YourTable[WorkingDaysTillDueDate]
    RETURN
        SWITCH(TRUE(),
            days < 0, "Past Due",
            days = 0, "Due Today",
            days <= 2, "Due in Two Days",
            "On Track"
        )

When I run this today (25 Oct 2023) it gives me the following results for dates from 23 Oct to 30 Oct. And whenever you refresh the report, it will recalculate both Calculated Columns based on the current today's date.

You will need to maintain the dimDate table by populating it with any future dates and what the WorkingDays field should be for each.

Hopefully this helps.