# Split/filter infinite Calendar by weeks

1. ## Split/filter infinite Calendar by weeks

hello

i have an employee working shift spreadsheet with an infinite mothly calendar

now: i would like to now the formulas to show the employee shift from top but split by the selectet week starting mondays

Captura.JPG

Captura 2.JPG

i ad the file so you can see better

HORARIO.xlsm

2. ## Re: Split/filter infinite Calendar by weeks

C38
=WORKDAY(DATE(\$B\$32,MATCH('Shift Rotation Schedule'!\$B\$31,'Hidden Settings'!\$A\$2:\$A\$13,0),0),\$B\$35*5-4)

D38
=C38+1
Copy to the right

3. ## Re: Split/filter infinite Calendar by weeks

thank you for you quick response

that is what i was looking for ,

but it is posible also to automatlly show the same value from each cell under the dates

exaple : if angel work on the 10th "mm" it should appear same in week filter
Attachment 635178

is it a look up funtion ?

thank you for your assistance one more time

4. ## Re: Split/filter infinite Calendar by weeks

C39
=IFERROR(INDEX(\$C6:\$AG6,MATCH(C\$38,\$C\$5:\$AG\$5,))&"","")

or
=IFERROR(INDEX(\$C\$6:\$AG\$27,MATCH(\$A39,\$A\$6:\$A\$27,),MATCH(C\$38,\$C\$5:\$AG\$5,))&"","")

5. ## Re: Split/filter infinite Calendar by weeks

thank you

yes it worked too ,

but can i ask you the favor to check for me one more time the dates ,if i select mounth and year it seems donīt match the date in the week section
it only seems to work o match just with the mounth of june 2019 selecting other mounths or years does not change the dates of week section

Attachment 635401

Attachment 635402

also selecting december it goes to error complete

Attachment 635403

I appreciate all your help patience and work

6. ## Re: Split/filter infinite Calendar by weeks

Originally Posted by bluepomme
if i select mounth and year it seems donīt match the date in the week section

also selecting december it goes to error complete
DICIEMBRE

Hidden Settings A13 => DECIEMBRE

7. ## Re: Split/filter infinite Calendar by weeks

sorry for that .

i upload one more time as seen oin the pictures when i select the year or mounth , week calendar does not change propertly , it seems only working for june 2019 i alrade tried to change but could not get it to work

Captura3.JPG

Captura1.JPG

8. ## Re: Split/filter infinite Calendar by weeks

DICIEMBRE

Hidden Settings A13 => DECIEMBRE[/QUOTE]

my bad i did not see it

9. ## Re: Split/filter infinite Calendar by weeks

I see, Please try at C38
=WORKDAY.INTL(DATE(\$B\$32,MATCH('Shift Rotation Schedule'!\$B\$31,'Hidden Settings'!\$A\$2:\$A\$13,0),0),B35,"0111111")

10. ## Re: Split/filter infinite Calendar by weeks

im sorry it did not work as expected, it still not match
may you can take another look into the file by yourself

the formula you give before did better results but just for june 2019

Attachment 635615

thank you

11. ## Re: Split/filter infinite Calendar by weeks

Originally Posted by bluepomme
im sorry it did not work as expected, it still not match
This doesn't give me useful information to work on.

"Invalid Attachment specified"
This is what I get

bb.jpg

If this does not work, I'm out of ideas. you need to find other help.

12. ## Re: Split/filter infinite Calendar by weeks

Excellent it's all working now

thank you for all your effort ,

There are currently 1 users browsing this thread. (0 members and 1 guests)