You need to use WORKDAYS in order to get the number of working days between two dates in MySQL. IE: WORKDAYS(t.date_column_1, t.date_column_2)