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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elaine - 24 Oct 2004 02:15 GMT

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?

Reply to this Message

- 24 Oct 2004 04:05 GMT

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...

>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?

Reply to this Message

Peo Sjoblom - 24 Oct 2004 05:50 GMT

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

Signature

Regards,

Peo Sjoblom

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

> say the dates you have now are in col A
>
[quoted text clipped - 14 lines]
>> do
>> I do that?

Reply to this Message