Thread: First Monday
View Single Post
  #3   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

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