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