[Solved] In Excel, change only the year component of a 9to5Answer
Excel Change Year In Date. Web replied on may 15, 2012. With a column of date in column a, in b1 enter:
[Solved] In Excel, change only the year component of a 9to5Answer
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. Web how do i change just the year component of a date using excel formulas? To change the year in a date, select the cell where you want the new date to appear.
Web replied on may 15, 2012. Web how do i change just the year component of a date using excel formulas? 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. =date (2009,month (a1),day (a1)) and copy.
