Thread: contact list whose sequence changes with date

Hello,
I want to create an on-call contact list in Excel 2010 that rotates the order from week to week.

At the moment, there are 5 people in rotation, but to simplify it, here's what I'd be thinking of if there were only 3-people on call:

Week 1:
John 703.555.5555
Steve 703.666.6666
Mike 703.777.7777

Week 2:
Steve 703.666.6666
Mike 703.777.7777
John 703.555.5555

Week 3:
Mike 703.777.7777
John 703.555.5555
Steve 703.666.6666

Any suggestions on how I'd go about setting this up in Excel 2010?

Thanks in advance for any suggestions.

Svend

I guess this question is a bit too open-ended.

At the moment, my spreadsheet gets the week number based on the current date and has a list of contacts in a separate worksheet.

I'm trying to think through the formulas/functions for these 2 tasks:
1) Identify the value that corresponds to the week # (presumably using a equation that divides the 52 by the number of people on the list).
2) Populate the rest of the list as appropriate (i.e., if this week is the first guy's week then plug in the remaining people on the reference list without modification; otherwise, plug in the remaining people on the list, then the people preceding him on the list).

Thanks.

Never mind about #1. I think I have that worked out:
=MOD(WEEKNUM(NOW()),COUNTA(People!$A:$A))+1

That gives me a value from 1 to the total # of people on the list, so I've figured out how to grab the current person (i.e., the person who should be displayed as #1).

That just leaves populating the remaining fields (i.e., #2).

Okay, I figured it all out. I will attached the worksheet once I have it in presentable form.

Turned out to be pretty straight forward once the coffee had kicked in!

Thanks.