Every 1st, 3rd, 5th Tuesday

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
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
Click to expand...

A2: =A1+7

Fill down as far as required.
--ron
 
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
Click to expand...

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)
 
Geez, I feel very embarrassed to have posted that question!

Thanks Ron/Rick for your responses.

Ricky
(smacking his forehead after realizing the solution)
Click to expand...

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
 
Back
Top