A tough problem

[Patrick Simonds]

I have a workbook with 4 Worksheets

June - August
September - November
December - February
March - May

Across the top of each worksheet I need the date of the 2nd and 4th Tuesday
of each month (June - August, September - November ect). Now I know I can
just sit down and enter this manually, but I want this to automatically
update depending on the year which I have entered in cell A1. I am at a loss
for how to do this, so any of you miracle workers out there have any ideas?

 

[Don Guillett]

See if this helps
http://tinyurl.com/cvgep

 

[Don Guillett]

even more
http://tinyurl.com/9l2ld

 

[Ron Rosenfeld]

I have a workbook with 4 Worksheets

June - August
September - November
December - February
March - May

Across the top of each worksheet I need the date of the 2nd and 4th Tuesday
of each month (June - August, September - November ect). Now I know I can
just sit down and enter this manually, but I want this to automatically
update depending on the year which I have entered in cell A1. I am at a loss
for how to do this, so any of you miracle workers out there have any ideas?

With the year in A1, (and Mnth=the number of the month) the second Tuesday of
any given month is given by the formula:

=DATE(A1,Mnth,15)-WEEKDAY(DATE(A1,Mnth,12))

The 4th Tuesday would be the above +14


--ron