With help from Chip Pearson (http://www.cpearson.com/excel/DateTimeWS.htm)

Enter any date during the month in question in cell A1:

=DATE(YEAR(A1),MONTH(A1),1)+CHOOSE(WEEKDAY(DATE(YE AR(A1),MONTH(A1),1)),1,0,6,5,4,3,2)

gives you the first Monday.

=DATE(YEAR(A1),MONTH(A1),1)+CHOOSE(WEEKDAY(DATE(YE AR(A1),MONTH(A1),1)),4,3,2,1,0,6,5)+7

Gives you the second Thursday.

Hope this helps
Rowan

"Charlie O'Neill" wrote:

If Jan/02/06 is the first Monday of the month how can I determine the date of
the first Monday in Feb, March, Apr. and so on. I would also like to be able
to determine the date for the 2nd Thursday of each month.

Thanks
Charlie