Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 22

Thread: Adding Dates

  1. #11
    New Member
    Join Date
    Feb 2002
    Location
    Louisiana USA
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =EDATE((A1),6) Or Just add the daye like in your formula in your last post.Good Luck

  2. #12
    New Member
    Join Date
    Feb 2002
    Location
    Louisiana USA
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =EDATE((A1),6)
    If Cell A1 contains your orginal date, paste this formula in the cell you want the new date, Or Just add the days like in your formula in your last post.Good Luck, Sorry about the double post.

    [ This Message was edited by: Sam W on 2002-04-28 19:27 ]

  3. #13
    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-28 15:33, gymwrecker wrote:
    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.
    Hi gymwrecker:
    I gave two formulas before that you can use.
    If cell J2 is formatted as DATE, then you can use one of the following two formula to add six months to the date in cell J2. So in cell J3, put one of the following formulas:

    =EDATE(J2,6) ... this will give you 09-May-02

    =date(year(J2),month(J2)+6,day(J2)) ... this will also give you 09-May-02
    You may have to format the cell J3 to show date in the format to your liking.

    Hope This Helps!



    Regards!

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

  4. #14
    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 Sam W:
    Sorry, I did not see your post till after I posted mine.

    Regards!

    Yogi Anand

  5. #15
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-28 15:33, gymwrecker wrote:
    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.
    gym,

    Yogi's suggestion is the most strightforward in my mind, i.e. use the following formula in J3:

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

    This avoids assumptions about the lengths of months which other approaches seem to involve.

  6. #16
    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

    Thanks a lot Yogi!!! Your formula worked instantly. It saved me a lot of work.
    Now, is there a way to use multiple formulas within the same cell?


  7. #17
    Board Regular
    Join Date
    Feb 2002
    Location
    Scotland
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Type this Formula in J3 to return the ans you requested

    =DATE(YEAR(J2)+0,MONTH(J2)+6,DAY(J2)+0)

  8. #18

    Join Date
    Feb 2002
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-28 20:01, sreed wrote:
    On 2002-04-28 15:33, gymwrecker wrote:
    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.
    gym,

    Yogi's suggestion is the most strightforward in my mind, i.e. use the following formula in J3:

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

    This avoids assumptions about the lengths of months which other approaches seem to involve.

    Sorry, but I don't think your claim "This avoids assumptions about the lengths of months which other approaches seem to involve" is correct.

    If the start date is, for example, 30 Aug 2002, the formula you propose will produce 2 Mar 2003.

    Also, problems can arise with EDATE when the start date is the last day of a month.
    With kudos to C. O. Jones, who has made many postings to this board about this problem, if the start date happens to be the last day of a month :

    - if a result is expected which is also the last day of a month (e.g. 28 Feb 2002 + 6 months = 31 Aug 2002), then :
    =IF(EOMONTH(A1,0)=A1,EDATE(A1+1,6)-1,EDATE(A1,6))

    - if a result is expected which is not necessarily the last day of a month (e.g. 28 Feb 2002 + 6 months = 28 Aug 2002), then :
    =EDATE(A1,6)

  9. #19
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if you have ge starting date in A1

    in a2 put this formula

    =DATE(YEAR(A1),MONTH(A1)+6,MIN(DAY(A1),DAY(DATE(YEAR(A1),
    MONTH(A1)+7,0))))

    it works


  10. #20

    Join Date
    Feb 2002
    Posts
    36
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-04 05:34, sen_edp wrote:
    if you have ge starting date in A1

    in a2 put this formula

    =DATE(YEAR(A1),MONTH(A1)+6,MIN(DAY(A1),DAY(DATE(YEAR(A1),
    MONTH(A1)+7,0))))

    it works

    You say it works, but that depends upon what result the user expects.
    Your formula does exactly the same (I think) as =EDATE(A1,6).
    But see my previous posting - some users may expect results produced by =IF(EOMONTH(A1,0)=A1,EDATE(A1+1,6)-1,EDATE(A1,6))

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
  •