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