Changing dates

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Just noticed that I have a large amount of dates that are
the wrong year.
The month and day are correct.

Any way of just changing the year?

Thanks
Adam
 
Adam,

In a separate cell, put the number of days to add in, such as 365 for 1
year, etc, and copy that cell.

Then, select the date cells, goto menu Edit>PasteSpecial and select the Add
button in the Operation, and click OK.

May not work for all dates if there is a leap year for some when years are
incremented, and not others, and the number of days to add is not
consistent.
 
Assume dates are in A1 to A10
in an adjacent column

=Date(2005,month(a1),Day(A1))

or if you want to add 1 year (as an example

=Date(Year(A1)+1,month(a1),Day(A1))

Then drag fill down the column.

Select these cells and do Edit=>copy, then select A1 and do
Edit=>Pastespecial and select values.
 
Back
Top