Adding years to a date in a column

**mileena** · 07-29-2011, 01:08 AM

Hi. I want to add the date from one column to 5 years, which will be in another column. How do I do this? I have tried searching, but with no luck. This is good for auto insurance, which takes the date of your traffic incident or conviction, plus 3 or 5 years, to see if they are allowed to consider that when rating you. State law usually lets them consider it if it is up to 3 or 5 years old, depending on the state and insurance company.

I actually plan to use the formulae in OpenOffice Calculator, but I wanted to know the Excel formulae. Usually the formulae are the same in both programs, except OpenOffice uses colons ( : ) where Excel uses semi-colons ( ; ), I think.

Thanks!

**ConneXionLost** · 07-29-2011, 01:38 AM

Hi,

Try this:

Please Login or Register  to view this content.

Cheers,

**mileena** · 07-29-2011, 02:11 AM

Originally Posted by ConneXionLost

Hi,

Try this:

Please Login or Register  to view this content.

Cheers,

Thanks! That looks like a nice formula. I tried it in OpenOffice Calculator, which is the open-source equivalent of Microsoft Excel, but it did not work, probably because there are differences between the programs. I did remember to change the A2's to the appropriate cells in my spreadsheet.

Maybe I should do a search for OpenOffice formulae. I wish I had Excel 2007 or 2010. I already used up my free trials though.

**royUK** · 07-29-2011, 02:18 AM

Works for me in OpenOffice

=DATE(YEAR(A1)+5;MONTH(A1);DAY(A1))

**mileena** · 07-29-2011, 02:34 AM

Originally Posted by royUK

Works for me in OpenOffice

=DATE(YEAR(A1)+5;MONTH(A1);DAY(A1))

Got it! It worked! I had used commas in the formula instead of semi-colons, which OpenOffice requires.

**royUK** · 07-29-2011, 03:08 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save