Rotating roster move cell down based on date

I have a basic 6 man rota I am new to using formulas and i am try to automate the rota so that each person moves down a line each week. I.E Person on line 1 moves to line 2 , line2 to line3 so on and Line6 moves back to line 1. I have attached a sample of the rota.

This would be a much easier task with helper columns, but I'll admit that it was more interesting without them. Try putting the following formula in C6 and filling down through C11. I altered it to fit your dates, so Warren should be the top name currently. This will put Brian in the top position come the week of April 10th, as in your sample.

=IF(MOD(WEEKNUM(TODAY(),1),6)=MOD(ROW()-2,6),"Brian",IF(MOD(WEEKNUM(TODAY(),1),6)=MOD(ROW()-3,6),"Paul",IF(MOD(WEEKNUM(TODAY(),1),6)=MOD(ROW()-4,6),"Warren",IF(MOD(WEEKNUM(TODAY(),1),6)=MOD(ROW()-5,6),"Daniel",IF(MOD(WEEKNUM(TODAY(),1),6)=MOD(ROW()-6,6),"David",IF(MOD(WEEKNUM(TODAY(),1),6)=MOD(ROW()-1,6),"Danyelle"," < Error > "))))))

The formula is based off of the current date, so it should automatically update every Sunday