Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Month plus 1 (Excel 2000/2003)

    Hi there
    If a cell contains a date formatted in yyyy-mm-dd i.e. 2004-08-01. How do I add one month to it so that it will display 2004-09-01 or a month later than the first date?
    Regards

  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: Month plus 1 (Excel 2000/2003)

    If your start date is A1 then

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

    should work.

    However if the date in A1 is 31/1/2004 then the above would return 2/3/2004.

    To get round that and return the last day of february you could use :

    =MIN(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),DATE(YEAR( A1),MONTH(A1)+2,DAY(1))-1).

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Month plus 1 (Excel 2000/2003)

    If you have the Analysis Toolpak installed, the EDATE function will do exactly as you want. Again you should test to make sure it does what you want when the next month has fewer days than the previous month.

Posting Permissions

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