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