How To Change The Year In Excel. To change the year in a date, select the cell where you want the new date to appear. With a column of date in column a, in b1 enter:
Calculating year over year in Excel YouTube
=date (2009,month (a1),day (a1)) and copy. With a column of date in column a, in b1 enter: To change the year in a date, select the cell where you want the new date to appear. Web replied on may 15, 2012.
To change the year in a date, select the cell where you want the new date to appear. Web replied on may 15, 2012. =date (2009,month (a1),day (a1)) and copy. With a column of date in column a, in b1 enter: To change the year in a date, select the cell where you want the new date to appear.
