Date except the WE or a specific day

[jeremy.desmauts]

I want to generate a set of data over one month but without a specific day.
Actually, I don’t any value for this day.

I am currently using sql date value.

Thank you
Jeremy