I'm using excel 2007.
I have my two top rows frozen and dates in column A.

Is there any way to create a tag within my worksheet that will allow cell A1 to switch years when the date in column A switches from one year to the next?

I want to be able to view which year im in by looking at cell A1.

Thanks!