Take a look he

http://cpearson.com/excel/DateTimeWS.htm#NthDoW

In article .com,
"lawdoggy" wrote:

I need to figure out all the 2nd and 4th wednesdays for all year long.
These days are set and are used for the same purpose (training) so I
would like to be able to print a list instead of hunting down a
calendar and counting. Any help would be greatly appreciated!