I have a large spreadsheets with a list of events and 2 columns for dates.
The date that the even was originally scheduled for and the date that it
actually happened.
The events go into next year and just realized that starting Jan 1, 2009 the
dates are erronously listed in the format 01/01/08 as 2008. So I need to
update all the dates from Jan forward to read XX/XX/09, how can I do this
without affecting the 2008 dates.

So you want to change Jan 08 dates to read Jan 09? Presumably also for
Feb 08 and Mar 08 ... etc

When do you want to stop, though? up to June 08, August 08 ?

Do you want to change all dates, or just the ones in the original
schedule column?

Pete

On Oct 1, 3:16*pm, marf wrote:
I have a large spreadsheets with a list of events and 2 columns for dates..
The date that the even was originally scheduled for and the date that it
actually happened.
The events go into next year and just realized that starting Jan 1, 2009 the
dates are erronously listed in the format 01/01/08 as 2008. So I need to
update all the dates from Jan forward to read XX/XX/09, how can I do this
without affecting the 2008 dates.

basically it looks like this:

10/01/08
11/01/08
12/01/08
01/01/08 - should read 01/01/09
02/01/08 - should read 02/01/09
..
..
..


"marf" wrote:

I have a large spreadsheets with a list of events and 2 columns for dates.
The date that the even was originally scheduled for and the date that it
actually happened.
The events go into next year and just realized that starting Jan 1, 2009 the
dates are erronously listed in the format 01/01/08 as 2008. So I need to
update all the dates from Jan forward to read XX/XX/09, how can I do this
without affecting the 2008 dates.

I would say the dates are text, not real dates.

Select the first 3 and DataText to ColumnsNextNextColumn Data
FormatDateMDY and Finish.

Now drag/copy those down the column.


Gord Dibben MS Excel MVP

On Wed, 1 Oct 2008 08:32:03 -0700, marf
wrote:

basically it looks like this:

10/01/08
11/01/08
12/01/08
01/01/08 - should read 01/01/09
02/01/08 - should read 02/01/09
.
.
.


"marf" wrote:

I have a large spreadsheets with a list of events and 2 columns for dates.
The date that the even was originally scheduled for and the date that it
actually happened.
The events go into next year and just realized that starting Jan 1, 2009 the
dates are erronously listed in the format 01/01/08 as 2008. So I need to
update all the dates from Jan forward to read XX/XX/09, how can I do this
without affecting the 2008 dates.