>I can only think of the following formula to determine the week number in a month by date:
>
>
>? CEILING(DAY(dMyDate)/7)
>
>
>That is I want to find out if a date is 1st, 2nd, 3rd, 4th (or 5th) Monday, Tuesday (whatever the DOW of the dMyDate is).
>
>Does the above make sense and is it the shortest?
>
Looks familiar, check
Re: Week() of the Month Message #
744488. :)
--sb--