Results 1 to 2 of 2

Thread: Repeat data string after changing year

  1. #1

    Repeat data string after changing year

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

    Attached Files Attached Files

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Victoria, Canada
    Excel Version
    Microsoft Excel 2013
    It's generally best to use a date for doing calendar calculations. Give this a try.

    taedo 2012-06-24.xls


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts