That's because I posted it before the original arrived in my NG client Rick.
Keen to correct my error <g

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rick Rothstein" wrote in message
...
Ah, I see his "oops" message now... I didn't associate it with this
sub-thread when I first read it.

--
Rick (MVP - Excel)


"Dave Peterson" wrote in message
...
Bob responded with an "oops" message. But he didn't respond to his post.

Rick Rothstein wrote:

I just tried it on a couple of April 2009 dates (April 1, 2009 is a
Wednesday) and it worked... can you show me an example month where it
fails?

--
Rick (MVP - Excel)

"Bob Phillips" wrote in message
...
I don't think this works if the 1st day of the month is a Wed.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Rick Rothstein" wrote in
message
...
Try this formula....

=DATE(YEAR(A1),MONTH(A1),22)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),4))

where A1 is assumed to contain any date within the month of interest.
Of
course, you may substitute the direct year and month for both of the
YEAR(A1) and MONTH(A1) function calls.

--
Rick (MVP - Excel)


"Chuck" wrote in message
...
How can I find the date (number) of the third wednesday of a month?

Chuck




--

Dave Peterson