Propagating a year to several cells containing a date

[Shinano]

I have a book with worksheets for each month of the year. Each sheet lists the dates of the month in column A, and the day of the week in column B. The cells in column B are merely a representation the cells in column A rerendered as =[cell reference] given the format ddddd.

I would like to make a references to the year, e.g. in A1, so that I only need to change the year in one cell for the entire book and subsequently it will propagate to all dates and weeksdays in all worksheets in the entire book automatically.

Any ideas?

Thank you.

 

[Krishnakumar]

Book2
	A	B	C	D
1	2006
2	1/1/2006
3	1/2/2006
4	1/3/2006
5	1/4/2006
6	1/5/2006
Sheet1

Book2
	A	B	C	D
1	2006
2	2/1/2006
3	2/2/2006
4	2/3/2006
5	2/4/2006
6	2/5/2006
Sheet2

Select Sheet1!A1 and Define Year

Select all other sheets and in A1,

=Year

In A2 on sheet1,

=DATE(A1,1,1)

In A3 and copied down,

=A2+1

Do the same for other sheets.