In your WHERE clause, you could try:

WHERE DATEPART(dw, getdate()) in (2, 3, 4, 5, 6)

That should give you only weekdays.