moving date details

[Guest]

Hi All

Wondered if you could help with the following on Excel: I would like to
convert a series of dates (from different months in 2006) to the month of
April 2007, but to keep the day of the month i.e. 1st or 2nd the same. See
below:

Old New
01/08/2006 01/04/2007
03/09/2006 03/04/2007
04/10/2006 04/04/2007
11/10/2006 11/04/2007

Is there a way to do this on Excel? I am using Excel 2002 (and in UK so
other way around to USA). Any help greatly appreciated

Kind regards

Rexmann

 

[Guest]

If the original date is in A1 then:

=DATE(2007,4,DAY(A1))

 

[Guest]

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

With the date in A1

 

[Guest]

Thanks to both of you - worked a treat

Cheers Rexmann