Every 1st, 3rd, 5th Tuesday

[Rick]

Hi,

I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month.

How can I get the cells below populated with the dates of the 1st, 3rd
and 5th Tuesdays of every month?

Tks, Ricky

 

[Ron Rosenfeld]

Hi,

I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month.

How can I get the cells below populated with the dates of the 1st, 3rd
and 5th Tuesdays of every month?

Tks, Ricky

A2: =A1+7

Fill down as far as required.
--ron

 

[Rick Rothstein \(MVP - VB\)]

I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month.

A2: =A1+7

+14 ???

Rick

 

[Ron Rosenfeld]

+14 ???

Rick

Duh, of course <hand slapping forehead>
--ron

 

[Ron Rosenfeld]

+14 ???

Rick

Actually, no, that would be wrong. As was my initial.


--ron

 

[Ron Rosenfeld]

Hi,

I have a start date of 2 Jan 07 in A1 - the 1st Tuesday of the month.

How can I get the cells below populated with the dates of the 1st, 3rd
and 5th Tuesdays of every month?

Tks, Ricky

Sorry, my first answer was incorrect.

Try this:

=A1+7+7*(MONTH(A1+7)=MONTH(A1))
--ron

 

[Rick]

Geez, I feel very embarrassed to have posted that question!

Thanks Ron/Rick for your responses.

Ricky
(smacking his forehead after realizing the solution)

 

[Ron Rosenfeld]

Geez, I feel very embarrassed to have posted that question!

Thanks Ron/Rick for your responses.

Ricky
(smacking his forehead after realizing the solution)

Best to check my last answer.
--ron

 

[Rick Rothstein \(MVP - VB\)]

Geez, I feel very embarrassed to have posted that question!

Don't be... initially, we were both wrong. However, Ron came up with the
correct formula afterwards.... check out his other responses.

Rick

 

[Rick]

Thanks for that formula Ron.

I just camne home form work ready to post the question again with
"that won't work".

But you guys already realised that!

Cheers, Ricky