>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?
If it's not broken, fix it until it is.
My Blog