>>Okay, but lets say I want to get the 2nd Tuesday of July, 2007. Presently I am determining the week day of 07/01/2007 and adding to it find the First Tuesday of July and then adding another 7 days. So in this case DOW() gives me a Sunday (1), add 2 and determine that July 3 is the 1st Tuesday, then add 7 to get the 10th which is the 2nd Tuesday.
>>
>>Works but seems kind of clunky. Was hoping that I am missing the obvious.
>
>May be this
Re: Week by Month Thread #
1180294 Message #
1180305 would work for you?
Thanks Naomi, this does give me something to consider. Need to sit down now and play with it some. But it does look promising.