Repeat data string after changing year

taedo

New member
Joined
Jun 24, 2012
Messages
1
Reaction score
0
Points
0
Hello Folks, I'm facing this new problem:
In the added example 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
 

Attachments

  • 1to35 with time.xls
    46 KB · Views: 14
Top