Dates

[k_babb]

Hi i want to make a calender to use in other sheets in a workbook
the problem is i would like to change the year on one worksheet and to automatically update all the sheets

so i have sheet1 with 01/jan in cell A1 02/jan in a2 and so on
then 01/feb in b1 02/feb in b2 and so on

what i would like to do is have a cell with 2011 in it and the just change this cell and for the dates to update so cell a1 would have 01/jan/2011
which would change to 2012 if i change the cell with the year in

any help would be great or if there is an easier way

 

[wigi]

Hello

Look at the Date function. It allows to specify year, month, day (in that order). The argument for the year could come from 1 central cell in the workbook. Just insert the reference to that cell instead of hard-coding 2011 or 2012.