I have a Labour Management Spreadsheet. Excel 2008 for Mac.

Column A = Surnames
Column B = FirstNames
Row 1 = Day of Week (mon, tues, wed)
Row 2 = Dates (03/05/2010)

I have done a freeze pane on cell C3 allowing me to scroll through the 45 members of staff, whilst retaining the dates along the top, and also allowing me to scroll through to future dates retaining A & B's names down the left.

How can I make excel jump to TODAY's column within the spreadsheet on startup?

Search Row 2 for TODAY, then scroll right, until this is the most left?

Thank you for any advice you can give.