Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: Adding Dates

  1. #1
    Board Regular gymwrecker's Avatar
    Join Date
    Apr 2002
    Location
    Fort Knox, KY
    Posts
    340
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm working on an excel spreadsheet that contains dates. If I have a cell with a specific date, how could, by adding 6 months, have the next cell display the new date? What formula, procedure should I use to add dates?, in this case, add six months to the date on one cell?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This may not be perfect, but it is close:
    If A1 contains the date:

    =A1+DATEVALUE("7/1")

    Tom

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-27 18:29, gymwrecker wrote:
    I'm working on an excel spreadsheet that contains dates. If I have a cell with a specific date, how could, by adding 6 months, have the next cell display the new date? What formula, procedure should I use to add dates?, in this case, add six months to the date on one cell?
    Hi gymwrecker:
    If your original date is in cell A2, then you can use the following formula ...

    =EDATE(A2,6) to get a date 6 months later than that in cell A2.

    HTH
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-27 18:35, TsTom wrote:
    This may not be perfect, but it is close:
    If A1 contains the date:

    =A1+DATEVALUE("7/1")

    Tom
    Hi Tom:
    With your formula I got the right day, the right month, but year-wise it took me way way into the future!

    Regards!

    Yogi Anand

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi gymwrecker and Tom:
    I could use a more straightforward formula ...

    =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))

    I still have to figure out the basis for Tom's suggestion though.

  6. #6
    New Member
    Join Date
    Apr 2002
    Location
    England
    Posts
    44
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I figured that there was a function to do this...

    This is what I originally had

    =A1+DATEVALUE("7/1/1900")

    Not

    =A1+DATEVALUE("7/1/")

    seeing that it would default to the current year and become the equivelant of :

    =A1+DATEVALUE("7/1/2002")

    Seems to work though...

    Tom

  8. #8
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    seeing that it would default to the current year and become the equivelant of :

    =A1+DATEVALUE("7/1/2002")

    Seems to work though...

    Tom
    Hi Tom:
    Let us try with today's date in cell A1 ... that would be
    =today()

    now if I add the date in cell A1 and datevalue("7/1/2002")

    =today()+datevalue("7/1/2002")

    you will notice that I get 10/27/2104

    that's what I meant earlier by way way into the future. The day comes out right, the month comes out right, but not the year.

    Regards!

    Yogi Anand


    [ This Message was edited by: Yogi Anand on 2002-04-27 19:11 ]

  9. #9
    Board Regular gymwrecker's Avatar
    Join Date
    Apr 2002
    Location
    Fort Knox, KY
    Posts
    340
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have cell J2 with 09 Nov 01, how could I make cell J3 read 09 May 02, J2 + 6 months?
    I have tried all your given formulas, but none have worked so far! Thanks for your replies.

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    what about if a1 has the date
    =a1+183

    that help

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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