Sharing Rota soloution

[scottylad2]

year planner

<table style="font-family: Arial,Arial; font-size: 10pt; background-color: rgb(255, 255, 255); padding-left: 2pt; padding-right: 2pt;" border="1" cellpadding="0" cellspacing="0"> <colgroup><col style="font-weight: bold; width: 30px;"><col style="width: 94px;"><col style="width: 87px;"><col style="width: 94px;"><col style="width: 88px;"><col style="width: 83px;"><col style="width: 85px;"><col style="width: 88px;"></colgroup><tbody><tr style="background-color: rgb(202, 202, 202); text-align: center; font-weight: bold; font-size: 8pt;"><td> </td><td>A</td><td>B</td><td>C</td><td>D</td><td>E</td><td>F</td><td>G</td></tr><tr style="height: 17px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td><td style="border: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Mon 20 Apr 09</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Tue 21 Apr 09</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Wed 22 Apr 09</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Thu 23 Apr 09</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 24 Apr 09</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 25 Apr 09</td><td style="border-top: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 26 Apr 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 27 Apr 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 28 Apr 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 29 Apr 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 30 Apr 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Fri 1 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sat 2 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sun 3 May 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Mon 4 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 5 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 6 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 7 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Fri 8 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sat 9 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sun 10 May 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 11 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Tue 12 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Wed 13 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Thu 14 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 15 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 16 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 17 May 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 192, 0); font-family: Calibri; text-align: center;">Mon 18 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 192, 0); font-family: Calibri; text-align: center;">Tue 19 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 192, 0); font-family: Calibri; text-align: center;">Wed 20 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 192, 0); font-family: Calibri; text-align: center;">Thu 21 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 22 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 23 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 24 May 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 25 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 26 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 27 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 28 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Fri 29 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sat 30 May 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sun 31 May 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">9</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Mon 1 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 2 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 3 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 4 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Fri 5 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sat 6 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sun 7 Jun 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">10</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 8 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Tue 9 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Wed 10 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Thu 11 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 12 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 13 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 14 Jun 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">11</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Mon 15 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Tue 16 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Wed 17 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Thu 18 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 19 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 20 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 21 Jun 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">12</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 22 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 23 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 24 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 25 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Fri 26 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sat 27 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sun 28 Jun 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">13</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Mon 29 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 30 Jun 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 1 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 2 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Fri 3 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sat 4 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sun 5 Jul 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">14</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 6 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Tue 7 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Wed 8 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Thu 9 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 10 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 11 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 12 Jul 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">15</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Mon 13 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Tue 14 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Wed 15 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Thu 16 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 17 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 18 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 19 Jul 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">16</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 20 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 21 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 22 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 23 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Fri 24 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sat 25 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sun 26 Jul 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">17</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Mon 27 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 28 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 29 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 30 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Fri 31 Jul 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sat 1 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sun 2 Aug 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">18</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 3 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Tue 4 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Wed 5 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Thu 6 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 7 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 8 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 9 Aug 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">19</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Mon 10 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Tue 11 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Wed 12 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Thu 13 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 14 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 15 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 16 Aug 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">20</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 17 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 18 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 19 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 20 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Fri 21 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sat 22 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Sun 23 Aug 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">21</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Mon 24 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 25 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 26 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 27 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Fri 28 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sat 29 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Sun 30 Aug 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">22</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 31 Aug 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Tue 1 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Wed 2 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Thu 3 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 4 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 5 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 6 Sep 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">23</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Mon 7 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Tue 8 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Wed 9 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 255, 0); font-family: Calibri; text-align: center;">Thu 10 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 11 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 12 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 13 Sep 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">24</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 14 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 15 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 16 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 17 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(149, 179, 215); font-family: Calibri; text-align: center;">Fri 18 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(149, 179, 215); font-family: Calibri; text-align: center;">Sat 19 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(149, 179, 215); font-family: Calibri; text-align: center;">Sun 20 Sep 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">25</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(149, 179, 215); font-family: Calibri; text-align: center;">Mon 21 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Tue 22 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Wed 23 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Thu 24 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 192, 0); font-family: Calibri; text-align: center;">Fri 25 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 192, 0); font-family: Calibri; text-align: center;">Sat 26 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(255, 192, 0); font-family: Calibri; text-align: center;">Sun 27 Sep 09</td></tr><tr style="height: 20px;"><td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">26</td><td style="border-left: 1px solid rgb(0, 0, 0); border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Mon 28 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Tue 29 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Wed 30 Sep 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(197, 217, 241); font-family: Calibri; text-align: center;">Thu 1 Oct 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Fri 2 Oct 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sat 3 Oct 09</td><td style="border-right: 1px solid rgb(0, 0, 0); border-bottom: 1px solid rgb(0, 0, 0); background-color: rgb(236, 233, 216); font-family: Calibri; text-align: center;">Sun 4 Oct 09</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); font-family: Arial; font-size: 10pt; background-color: rgb(255, 252, 249); color: rgb(0, 0, 0);"><tbody><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family: Arial; font-size: 9pt;" border="1" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(202, 202, 202); font-size: 10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>A3</td><td>=VLOOKUP(TODAY(),$M$3:$M$54,1,TRUE)</td></tr></tbody></table></td></tr></tbody></table>
Each Monday thats Yellow in column A is the start of a cycle on my Rota. It repeats every 28 days. The yellow are day shifts, the nights are in blue and white are days off. In a separate list, i have all the Yellow mondays listed, 52 in total which spans the next 4 years. I have 2 other colums, one called days the other called nights, which is where i record if i'm taking a holiday. It goes in the appropriate days or nights column and my rota highlights the corresponding dates in Amber. .The conditional Formatting for that was supplied by someone on this board.

In A3 i have the vlookup listed above, all the other cells take whatever is in that cell as the start date and count from there. B3 =A3+1 etc, and the rows below all look one row above and +7. The current "rota period" is from 20/04/2009 through to 17/05/2009. on the next day, the 18thy, the vlookup will look at my list of dates and compare TODAY() with them and return an approximate match. Which should mean it will go from 18th to the next highest number, and return the lower number before that, which is the 18th. If all goes well, and it appeared to when i tested it, then the whole rota will start again from A3 showing 18th and all the formatted cells will retain their identifying colours. In essence, the whole rota will move up and a replenished 1 year rota should now be displaying, with all the holiday dates still shaded correctly. I used to have to do this by hand for several staff embers so it was labourious.

now.....my next "wish" is to be able to link several of these sheets to a master sheet. is it possible? The master will be for a quick viewing reference only and never needs to be printed out. It's so at a glance when holiday requests are made i can tell how many people are off already......If not poss then i'll just enjoy what i have. Don't ya just love Excel? !!
Excel tables to the web >> Excel Jeanie HTML 4