+ Reply to Thread
Results 1 to 6 of 6

Adding years to a date in a column

  1. #1
    Registered User
    Join Date
    07-29-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    3

    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!
    Last edited by mileena; 07-29-2011 at 06:57 PM.

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Adding years to a date in a column

    Hi,

    Try this:

    Please Login or Register  to view this content.
    Cheers,

  3. #3
    Registered User
    Join Date
    07-29-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adding years to a date in a column

    Quote Originally Posted by ConneXionLost View Post
    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.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Adding years to a date in a column

    Works for me in OpenOffice

    =DATE(YEAR(A1)+5;MONTH(A1);DAY(A1))
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Registered User
    Join Date
    07-29-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Adding years to a date in a column

    Quote Originally Posted by royUK View Post
    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.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Adding years to a date in a column

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1