Results 1 to 3 of 3

Thread: Dates (97:SR2)

  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dates (97:SR2)

    Is there an easy way to add 13 months to a date?

    Take for instance: 07/01/2003 whose numeric value is 37803.

    Thanks,
    John

  2. #2
    Star Lounger
    Join Date
    Apr 2002
    Location
    Vlissingen, Netherlands
    Posts
    63
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Dates (97:SR2)

    Hi,

    Take a look at Chip Pearson's website : http://www.cpearson.com/excel/DateAdd.htm

    Joop

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

    Re: Dates (97:SR2)

    If your date is in A1, the following should add 1 Year plus 1 Month (13 Months) to the value :

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

    or

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


    Andrew C

Posting Permissions

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