Can you post what you would want the query output to look like?

To me. your 'Tuesday or Friday' thing is a bit unclear. I mean, you could say, if it is the current week, you do tuesday if the date is pre-tuesday or friday if its pre-friday. But you are still saying 'Tuesday or Friday' for missed shipments. When would you ever ship next friday? If its next week couldn't you always do Tuesday?