Results 1 to 2 of 2

Thread: Formula for weekly rotation of lineup schedule

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Magician NoS's Avatar
    Join Date
    Jan 2013
    British Columbia
    Excel Version
    Excel 2010

    Formula for weekly rotation of lineup schedule

    Attempting to automate something currently done with pencil, paper and a calendar.
    Have managed to eliminate the calendar using a formula but having trouble creating the lineup for any given week.
    The attached workbook has what I'm starting with and the results I'm looking for.

    I'm hoping for a formula in cell B4 of the "Starting Point" sheet that can be dragged to fill the rotation schedule.

    The challenge I'm running into is that both the lineup and weeks are numbers but neither uses the number 13 which seems to create a moving target that I just can't hit. My formula to force 13 to 14 has eliminated the 13 but other numbers are being skipped in succeeding rows.
    Your assistance would be greatly appreciated.
    Thank you for your time.

    Attached Files Attached Files

Posting Permissions

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