Repeat data string after changing year

[taedo]

Hello Folks, I'm facing this new problem:
I got a year, an array with numbers from 1-35 and corresponding shifts, now the days start to count from 1 till 35 and then restart from 1, displaying the shifts, this goes from 1 januari till 31 december of that year, but when the last shift of that year is for example 31, then I need to be the first shift of the next year to become 32...if I just link them like I did in the example, I got a circular reference.
Is there a way to do this without VBA or programming, just using the formules? and if not, how could I solve this?

Thanks
Taedo

PS: I got a example on file, but I cannot upload it

 

[Tinbendr]

You'll have to use a service like box.com or goggle docs to post a link for the file.

 

[taedo]

Thanks for all those trying, I found a solution
Kind regards
Taedo