How can I include a variable in an Excel page header
 

I'd like to include the value from the 1st or last row of each page in the
header of an Excel spreadsheet.
E.g. If the first column contains a date, and there is a page change after
each month, I'd like to be able to have a Header text like "Report for the
month of [=TEXT(A*i, "mmm-yy")]"
where A*i is the "first-row-of-current-page" respectively.
In other words, if 40 rows fit on each page and cell A1 contains the date
1-Jan-2005 and cells A2-A80 contain dates in Jan-05 while A81-A100 contain
dates in Feb-05 and A101-200 contain dates in Mar-05 then then header for
pages 1+2 should read "for the month of Jan-05", that of pg.3 should read
"for the month of Feb-05", and that of pages 4-5 should read "for the month
of Mar-05"