[Solved] Years every second tuesdays listing by month

[Colabo2011dates]

I attached example.

U can see A column have a list of every second tuesdays (+14 from 1 weeks tuesday).

Like below:
2012-01-03 Tu
2012-01-17 Tu
2012-01-31 Tu
2012-02-14 Tu
2012-01-28 Tu

Cells column E F G shoud contain only month specified like January.

Code: Select all

  Cell E         Cell F         Cell  G
January         February        March

First - i dont know how to make column E show only January.

Second - i calculte eatch second tuesday. And those are changing each years.
For example if 2012 January has 3 tuesdays. 2013 has only 2 tuesdays. (each second +14 days)

So i thinking is there a way to calculate those yearly tuesdays in such way that january tuesdays would by in one column February in other. But they shoud by also early tuesdays not just special month tuesdays.

[acknak]

If I understand correctly what you're after, this may give you some ideas...

The formula is MrProgrammer's; see http://user.services.openoffice.org/en/ ... =9&t=36849

[Colabo2011dates]

Formula is fine. But i need 1 - 3 - 5 - 7 - 9 and so on Tuesdays list.
Its not exacly second mothly Tuesday, its yearly shedule that is build from each second Tuesdays.

The problems are that Example - 2011 have more Tuesdays then 2013. If i add formula in to 3 cells that have eatch second Tuesdays its fine but after years change same month will have only 2 eatch second Tuesday.

Example below
2011 years have:
January 4 -is FIRST TUESDAY
January 11
January 18 - is SECOND TUESDAY
January 25

2013 years have:
January 1 - is FIRST TUESDAY
January 8
January 15 - is SECOND TUESDAY
January 22
January 29 - is THIRD TUESDAY

So if i have speciffied month and added 3 cell what happens? I getting other months Tuesday in list that shoud contain only specified month Tuesdays.

If i do something wrong and its possible to use this formula in better way pls correct me.

[JohnSUN-Pensioner]

Do you need to limit the output values ​​for a month? Just use the functions IF and MONTH