On Tue, 8 Apr 2008 11:32:14 +0100, "Wendy" wrote:

Hi Ron

It doesn't matter it is the 1st monday in april it is still the start of
week2.
Can you suggest a way round this to make it work?



With the specifications you have supplied, only by making both yesterday and
next Monday = W2Mon.

You have written:

" 2nd Monday is always W2Mon "

and also:

"It doesn't matter it is the 1st monday in april it is still the start of
week2."

The only way I see to resolve these two statements is to make both yesterday
and next Monday to be W2Mon.

If that is not what you want, then you will have to lay out unambiguous
specifications.
--ron