Excel 2007 : Changing the month

Hi

Attached is the file and wish to know (may be something) that if date 31 crosses the freezed line month shall automatically change to the next one, i.e, currently its for december but when 31 crosses freezed pane/line it should get automatically changed to January.

Thanks

The macro below will change the month and move the active cell to the first day of the month. For it to work you must tab or click in the white margin at the end of the calendar.

Please Login or Register  to view this content.

The last three day number cells in the calendar header contain formulas to determine if days past 28 are displayed for Feb & 30 day months:
AH2: =IF(AG2+1>DAY(EOMONTH($B$8,0)),"",AG2+1)
AI2: =IF(AH2="","",IF(AH2+1>DAY(EOMONTH($B$8,0)),"",AH2+1))
AJ2: =IF(AI2="","",IF(AI2+1>DAY(EOMONTH($B$8,0)),"",AI2+1))