G Gord Dibben Nov 7, 2008 #2 With great difficulty since the days of the weeks in each month are hard-wired. You could Edit>Replace 2008 with 2009 in column A but that's all you could do. Nothing else will change. Gord Dibben MS Excel MVP
With great difficulty since the days of the weeks in each month are hard-wired. You could Edit>Replace 2008 with 2009 in column A but that's all you could do. Nothing else will change. Gord Dibben MS Excel MVP