DATEPART("weekday",...) is my best friend here. Usually sales, etc. on mondays are similar to other mondays and so on...

Maybe I am overly used to this; but customers are astonished seeing that kind of stuff...