Question about modifying dates

[marf]

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.

 

[Pete_UK]

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

 

[marf]

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

 

[Gord Dibben]

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

Select the first 3 and Data>Text to Columns>Next>Next>Column Data
Format>Date>MDY and Finish.

Now drag/copy those down the column.


Gord Dibben MS Excel MVP