A rotator on Microsoft excel

[Death Row]

My friend is making a spreadsheet model and needs to make a rotating script. he needs it to change what table is shown in a lookup menu dependant of the day.
unfortunately i have no ideas on how to do this i am asking fo your help.

 

[office politics]

write a asp script

http://www.asp101.com/samples/database.asp

 

[Death Row]

write a asp script

http://www.asp101.com/samples/database.asp

Well thanks for the input but, this isn't really what im looking for. It's probably my fault for not having worded properly. What he needs is an Excel formula, like IF,OR statements etc. he doesn't need it to all to be one formula though, by that i mean if you think you can make it by putting one formula in one cell then another forumla in another etc. then that's fine.

 

[Death Row]

bump