+ Reply to Thread
Results 1 to 4 of 4

how to add number of years to certain date

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    58

    how to add number of years to certain date

    Hi all,

    I want formula to sum number to a date.
    Example,

    1/1/2013 + 3 = 1/1/2016

    Thanks

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,684

    Re: how to add number of years to certain date

    if the 1/1/2013 is in a cell say a1
    then in b1 put

    =DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))

    if 3 is also in a cell say B1
    then in C1 put
    =DATE(YEAR(A1)+B1,MONTH(A1),DAY(A1))
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: how to add number of years to certain date

    Try this: =EDATE(A1,3*12)
    1 year = 12 months

  4. #4
    Registered User
    Join Date
    07-10-2013
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: how to add number of years to certain date

    Thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting number of years from date to today
    By profitdr123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2015, 02:42 AM
  2. formula needed to add a number of years to a date
    By Maryjoefernandez in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-19-2013, 07:41 AM
  3. Age / Date / Number of Years Question
    By thnktwz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-22-2013, 11:20 AM
  4. Add number of Years to higher date in range
    By Knawl in forum Excel General
    Replies: 2
    Last Post: 11-30-2011, 06:21 AM
  5. Replies: 3
    Last Post: 08-22-2011, 11:58 AM
  6. display number of years based on a date
    By hoser in forum Excel General
    Replies: 2
    Last Post: 03-28-2009, 01:51 PM
  7. Replies: 9
    Last Post: 01-22-2009, 06:01 PM

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