Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Wels, Oberösterreich, Austria
    Posts
    64
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Adding time using months (Office 2003 (SP2))

    Hello there!
    Once again I'm stuck with excel. I have a spreadsheet containing several names of employees including their date of employment. For instance Mr. Smith started working of 12th March 2000, Mr. Summers started @ 21st November 1998, aso.
    In a second column I insert a period of time (in months), say 4. In the third column I would need the exact date resulting this function. Is there a formula available in excel which can do the trick? (12th March 2000 + 4 months= ?) <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>

    Help appreciated!
    Philipp
    __________________________________________________ ________
    Murphys Law rules the world, bow to it!

  2. #2
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding time using months (Office 2003 (SP2))

    Philipp:

    Assuming cell A1 has the start date (e.g. 12 March 2000) and B1 has the months to add (4 in your example) then the formula: =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) in C1 will give you 12 July 2000 as a date, which of course can be formatted as you wish. The formula can then be copied down the column.

    Regards,

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Adding time using months (Office 2003 (SP2))

    Make sure that Analysis ToolPak is installed (in Tools | Add-Ins...). This add-in has a function EDATE that does exactly what you want. With the employment date in A2 and the number of months in B2, the formula

    =EDATE(A2,B2)

    will return the date B2 months after the date in A2. (If B2 is negative, the date returned is before the date in A2). You'll probably have to format the result as a date.

  4. #4
    Star Lounger
    Join Date
    May 2002
    Location
    Wels, Oberösterreich, Austria
    Posts
    64
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Adding time using months (Office 2003 (SP2))

    Hi fellows!

    Thanks for your help. It worked just perfect!
    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Philipp
    __________________________________________________ ________
    Murphys Law rules the world, bow to it!

Posting Permissions

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