>>>>
>>>>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...
>
>Rewriting it:
>

>m.RealDaysToAdvance = m.DaysToAdvance + INT((m.TodayDow + m.DaysToAdvance) / 5.5) * 2


Hummm... back to the drawing board. This really is tricky... No wonder you were around this all day ;)