Changing dates

[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

 

[Bob Phillips]

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.

 

[Tom Ogilvy]

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.