Changing Year In Excel. Start by selecting the cell where you want the new date to appear. Web replied on may 15, 2012.
Pin on Learn Microsoft Excel
Web replied on may 15, 2012. =date (2009,month (a1),day (a1)) and copy. Start by selecting the cell where you want the new date to appear. To change the year in a date, select the cell where you want the new date to appear. Enter the formula =date (year, month, day) into. With a column of date in column a, in b1 enter:
Start by selecting the cell where you want the new date to appear. =date (2009,month (a1),day (a1)) and copy. Start by selecting the cell where you want the new date to appear. Enter the formula =date (year, month, day) into. With a column of date in column a, in b1 enter: Web replied on may 15, 2012. To change the year in a date, select the cell where you want the new date to appear.
