A tough problem
 

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?

See if this helps
http://tinyurl.com/cvgep
--
Don Guillett
SalesAid Software

"Patrick Simonds" wrote in message
...
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?

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

--
Don Guillett
SalesAid Software

"Patrick Simonds" wrote in message
...
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?

On Sat, 30 Jul 2005 09:38:55 -0700, "Patrick Simonds"
wrote:

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