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

On Tue, 12 Jun 2007 09:34:10 +0800, Rick wrote:

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

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

+14 ???

Rick

On Mon, 11 Jun 2007 22:10:24 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

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

+14 ???

Rick

Duh, of course <hand slapping forehead
--ron

On Mon, 11 Jun 2007 22:10:24 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

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

+14 ???

Rick

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


--ron

On Tue, 12 Jun 2007 09:34:10 +0800, Rick wrote:

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

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

Thanks Ron/Rick for your responses.

Ricky
(smacking his forehead after realizing the solution)

On Tue, 12 Jun 2007 09:34:10 +0800, Rick
wrote:

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

On Tue, 12 Jun 2007 11:08:57 +0800, Rick wrote:


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

Thanks Ron/Rick for your responses.

Ricky
(smacking his forehead after realizing the solution)

On Tue, 12 Jun 2007 09:34:10 +0800, Rick
wrote:

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

Best to check my last answer.
--ron

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

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

On Tue, 12 Jun 2007 09:34:10 +0800, Rick
wrote: