Adding years to a date in a column

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!

Hi,

Try this:

Please Login or Register  to view this content.

Cheers,

Works for me in OpenOffice

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

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