>>>>
>>>>I will try your approach. Although I don't like it ;) I have been thinking about it all day and you come up with a very simple formula :) Thank you!
>>>
>>>Assuming it works ;)
>>>
>>>My view? I think that sometimes we have to put some distance to a problem to get it solved. That is, sometimes what helps me is to stop thinking about a problem...
>>
>>I agree with you. My best solutions are either in my sleep or while I am taking a walk.
>
>And... going back to the code... I smell something funny regarding Saturdays...

And I'm wondering whether the problem is well defined. Why count weekdays only? Shouldn't it be workdays? If we mean business.

Then it's not just weekend days, it's holidays as well. So we better not go with a day-of-week parameter, but a date parameter, and have a list of workdays... a cursor, even better, which would contain all workdays. Then simply locate that date in the list (assuming we aren't starting off a day off) and then just skip n days - and return that record's date. Then we're depending only on the accuracy of this calendar.