Hi

I have a spreadsheet with a thousand or so records in it. Column H from row 3 onwards is the date in which particular companies were formed. So, column H holds a thousand plus different dates.

There is nothing in column I yet but what I would like to be able to do is to insert a new date into the cell for each record - BUT, the date shown myust be based on 10 year anniversaries of the formation of each company but only showing the next 10 year anniversary AFTER TODAYS date.

For example, if a date in one of the rows in column H is 25/07/1953, I would like the value added in the cell next to it to be 25/07/2013, not 25/07/1963.

Not all companies were formed in 1953 so the macro or programme will need to be able to differentiate between the years.

Below is an example of how it may start and how I would like it to look after running the programme.

Acme 27/05/1953
Test 13/09/1975
Another 16/10/1968

And after running the macro or program

Acme 27/05/1953 27/05/2013
Test 13/09/1975 13/09/2005
Another 16/10/1968 16/10/2008

As much information on how to achieve this would be greatly appreciated as I am not to familiar with programming.

It is not a problem if a new sheet is inserted when running the program in order to achieve this.

Thanks in advance

Malycom