change the year in a list of dates ex 1/3/2003 to 1/3/2004

[Elaine]

I have a list of dates, all in the year 2003 1/3/2003, and 5/17/2003, I want
to change just the year to 1/3/2004 and 5/15/2004 in the whole list. How do
I do that?

 

[Guest]

say the dates you have now are in col A

in a new column, type

=a1+365


and copy down

then do a /copy/special/values on the new column
so it becomes static and no longer refers to col A...
then delete col A and move teh new column to Col a

work on a copy of your file to make sure I have it right...

 

[Peo Sjoblom]

I assume the OP had a typo and really wanted 05/17/04, for example

01/03/03
03/01/03
05/17/03
12/01/03

with your method will return

01/03/04
02/29/04
05/16/04
11/30/04

however if one uses

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

will return

01/03/04
03/01/04
05/17/04
12/01/04


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)