Enter your date 2-jan-06 in A1,
In B1, enter: =WEEKDAY(A1)
A2:A12 enter 2, 3, 4... and so on for each month
B2: =DATE(YEAR($A$1),A2,1)
C2: =B2-WEEKDAY(B2)+$B$1+IF(WEEKDAY(B2)$B$1,7)
and drag down for all the first mondays in each month
for 2nd tuesday
=B2-WEEKDAY(B2)+$B$1+1+IF(WEEKDAY(B2)$B$1+1,14)
Alternatively, you can simply change the date in A1 to get a tuesday and in
the cell C2 change 7 to 14 to get 2nd tuesdays.
Mangesh
"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
|