How To Change The Year In Excel. 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.
Como usar a função DATE do Excel 2023
=date (2009,month (a1),day (a1)) and copy. 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.
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. With a column of date in column a, in b1 enter: Web replied on may 15, 2012. =date (2009,month (a1),day (a1)) and copy.
