Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    Chicago, Illinois, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add months to date help

    I'm using Excel 97. I have a column of dates expressed as 04/30/2001 and a column of number of months expressed as a single number, ie 30. I want to add the number of months to the date to find out what the date will be in 30 months in mm/dd/yyyy format. Hope this makes sense.

    Thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Add months to date help

    The following formula will add the the value in B1 to the month part of a date in A1, so if B1 = 12, then the formula will add 12 months (1 yr) to the date in A1.

    <big>=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))</big>

    You can format the cells containing the formula as required

    Andrew

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    Chicago, Illinois, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add months to date help

    Thanks Andrew. FYI - I also found out that EDATE will do the same thing.

    Regards,

    Brett

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Add months to date help

    Brett,

    yes EDATE() is fine, but you must have the Analysis Toolpak AddIn installed to use it. Not all users bother to install it.

    Andrew

Posting Permissions

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