>>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. :)
Thank you for confirming it. It seemed too simple <g>.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham