There I no clue based on which columns are calculated values for AJ:AR, but I think for AJ this must be something like
Code:
=NETWORKDAYS(
Table2[@[Date received]]+
IF(
AND(
Table2[@[Time received]]>0,5;
Table2[@[Date received]]<Table4[@[Date completed acceptance slip received from employee]]);
1;
0
);
Table4[@[Date completed acceptance slip received from employee]];
Holidays
)
NB! When time received > 12:00, then the calculation of working days starts from next day, except cases, when task is completed on same date.
Btw. With Table formulas, it is reasonable (to make reading and editing formulas easier):
1. to avoid special characters and spaces in column names;
2. to keep column names as short as possible.