I understand most of this formula, except for the number "5" in the weekday
function. Could someone please explain what purpose it serves? How would
it change if you were looking for the 2nd Tuesday, for example?

Thanks in advance.

"Harlan Grove" wrote in message
oups.com...

<snip The 2nd Wednesday in the month containing the date given in A3, one
could
use

=A3-DAY(A3)+14-WEEKDAY(A3-DAY(A3)+5,3)