correction formula given increase every 2 months
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: correction formula given increase every 2 months
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default correction formula given increase every 2 months

    Hello everyone.
    Is it possible in this forum for cross posting?
    max_max

  2. #2
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Hi to all.
    I hope my English is understandable.
    The formula in B6 increases the date of 2 months to every new year in B2
    It is possible to increase not every January 1 but the day / month of the date in B2?
    This post already posted here:
    correction formula given increase every 2 months
    The example is in post # 1
    max_max

  3. #3
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Hello to all,
    Maybe I did not explain it well?
    max_max

  4. #4
    Board Regular
    Join Date
    Jun 2013
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Hi, max_max!

    Place 2 or 3 handwritten examples of the result you want to get, so that we can help you better. Blessings!

  5. #5
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Hello jonmpl.
    I can not post an attachment, but there is another forum in post # 1.
    An example is this:
    in B6

    =IF(B4>0,IF(ISERROR(INT((YEAR(B2)-YEAR(B4))/6)&" "&"anno/i -"&" "&MOD((YEAR(B2)-YEAR(B4)),6)*2&" "&"mese/i" ),"",INT((YEAR(B2)-YEAR(B4))/6)&" "&"anno/i -"&" "&MOD((YEAR(B2)-YEAR(B4)),6)*2&" "&"mese/i" ),"")


    If B4 is not empty
    Every new year in B2
    The formula in B6 increases by 2 months

    example:
    B2= 01/01/2000
    B4= 01/05/2000

    B2= 01/01/2001
    B4= 01/05/2000
    B6= 0 anno/i - 2 mese/i

    B2= 01/01/2002
    B4= 01/05/2000
    B6= 0 anno/i - 4 mese/i

    B2= 01/01/2006
    B4= 01/05/2000
    B6= 1 anno/i - 0 mese/i

    The change is
    The formula must not start any new year's but the month of the date in B4.
    I hope I have explained.
    max_max

  6. #6
    Board Regular
    Join Date
    Jun 2013
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Hi, again!

    Is this? (in B6) :
    =IF(B4,IFERROR(INT(DATEDIF(B4,B2,"y")/6)&" anno/i - "&2*MOD(DATEDIF(B4,B2,"y"),6)&" mese/i",""),"")

    Try and comment! Blessings!

  7. #7
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    HI johnmpl,
    Your formula I think is right.
    It is possible to modify your formula: that when in B6 the formula becomes:
    5 anno/i - 0 mese/
    Even adding more years to B2 your formula stops?
    I hope I've been understandable.
    Anyway thanks for your formula.
    max_max

  8. #8
    Board Regular
    Join Date
    Jun 2013
    Posts
    233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    Quote Originally Posted by max_max View Post
    HI johnmpl,
    Your formula I think is right.
    It is possible to modify your formula: that when in B6 the formula becomes:
    5 anno/i - 0 mese/
    Even adding more years to B2 your formula stops?
    I hope I've been understandable.
    Anyway thanks for your formula.
    max_max
    Try:
    =IF(B4,IFERROR(MIN(INT(DATEDIF(B4,B2,"y")/6),5)&" anno/i - "&2*MOD(MIN(DATEDIF(B4,B2,"y"),30),6)&" mese/i",""),"")

    Blessings!

  9. #9
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    HI johnmpl,
    New formula is o.k.
    Thank you so much.
    Your formula in italian is:
    =SE(B4;SE.ERRORE(MIN(INT(DATA.DIFF(B4;B2;"y")/6);5)&" anno/i - "&2*RESTO(MIN(DATA.DIFF(B4;B2;"y");30);6)&" mese/i";"");"")
    max_max

  10. #10
    New Member max_max's Avatar
    Join Date
    Jun 2013
    Posts
    43
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: correction formula given increase every 2 months

    HI johnmpl.
    Your new formula:

    =IF(B4,IFERROR(MIN(INT(DATEDIF(B4,B2,"y")/6),5)&" anno/i - "&2*MOD(MIN(DATEDIF(B4,B2,"y"),30),6)&" mese/i",""),"")

    work in excel 2003?
    max_max


Some videos you may like

User Tag List

Tags for this Thread

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
  •