How to display the column containing today's date

I have a table of information - set-up to look similiar to a Gantt Chart utilising conditional formatting.

As this table spans a range of up to 5yrs I would like a way to automatically move to the column containing the current week on opening excel - the consecutive dates I am interested are shown in a specific range AI25:AI567

Is this possible?

You could make the column with todays date column A and freeze panes so that they're always visible.

Hope that helps.

-Z