>>>
>>>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
----------------------------------
António Tavares Lopes