good/bad condition derived from multiple dates

Dear reader,

I would like to ask for advice regarding the following:

Background info:

For orders we receive we keep track of multiple dates in an excel, which are consecutively:

1. date received
2. date rejected
3. date returned after rejection
4. acceptation date.

Between these dates there is a time limit for the processing time, which would be an interval of 10 workdays (excluding the date between 2-3).

Goal:

Creating an reporting visual on the dashboard stating a ‘good/bad’ status for each order. The status would be good if the time limit for each interval would not have been met, i.e.:

Conditions for the status being ‘good’ would be:

1-4 < 10 workdays

Conditions for the status being ‘bad’ would be:

1-4 > 10 workdays
1-2 > 10 workdays
3-4 > 10 workdays

Between these orders there may be cases when there is no rejection. Fields in the excel would be filled with “N/A”

So far:

I created a Calendar with a column that shows workdays showing either a 1 or a 0, with a 1 showing for workdays.

Workday = IF(OR('Date'[DayOfWeekNumber]=1;'Date'[DayOfWeekNumber]=7);0;IF(ISBLANK('Date'[Holiday]);1;0))

In the table with the orders I added some columns to calculate the difference in workdays between the different dates (1-2, 2-3, 3-4 and 1-4) showing me the number of workdays between two dates.

1-4 =

calculate(

    countrows('date');

    DATESBETWEEN('Date'[Date];'RI-2020'[date received]; 'RI-2020'[acceptation date]);

'Date'[Workday])

and

2-3 = if('RI-2020'[date rejected]="N/A";BLANK();calculate(countrows('date');DATESBETWEEN('Date'[Date];'RI-2020'[date returned]; 'RI-2020'[date rejected]);'Date'[Workday]))

For giving me blank fields when there is no date applied.

Critical part (for me ;):

I just can’t seem to string together a formula that would show me the previously stated good or bad conditions.

For a single statement it would be quite easy, something like:

if('RI-2020'[1-4]<10; "good"; "bad")

Adding all the bad conditions to this formula is where I find myself lost. Also including the blank fields

Any link to similar problems, help or advice would be greatly appreciated.