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!
Bookmarks