Stolen from Daniel Maher

=A1+7-WEEKDAY(A1+5)

where A1 holds the 1st date of any month so if A1 holds 01/02/2006 and in A2
you want the first Monday in February and A3 March and so on

=DATE(YEAR(A1),MONTH(A1)+1,1)+7-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,1)+5)

in A2 then copy down

for 2nd Thursdays

=A1+14-WEEKDAY(A1+2)

--
Regards,

Peo Sjoblom

(No private emails please)


"Charlie O'Neill" wrote in message
...
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