Thread: First Monday
View Single Post
  #5   Report Post  
Bob Phillips
 
Posts: n/a
Default

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