Hello,
I am trying to create a table that contains 4 columns.
In A2 I have the month.
In B2 I need to get a list of available week numbers that are in the month from A2. For example if A1=1 (januarry) then B2 list contains 1 to 4 weeknum, if a2=2 then B2 list contains 5 to 8 weeknums, and so on....
After this i need in C2 a list that contains the workingdays from the weeknum selected in B2. For example B2 is week 2 (year2015) then C3 has a list of selection that contains the days of the week, meaning 05.01.2015, 06.01.2015, 07.01.2015, etc......
In D2 I have the year for witch I allready made a list using data validation.
The range of expansion for this example is about 150 lines, so i must copy the formula in the cells bellow.
Hope this is duable and someone can help me.
Sory for my bad english.
Thanks in advance.
Bookmarks