Generic formula
=DATE(YEAR(A1),MONTH(A1),1+7*Nth)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),8-DoW))
Nth is the instance, 1st,.2nd etc, DoW is the serial number of the Day,
Sun=1, Mon=2, etc.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|