correction formula given increase every 2 months

[max_max]

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

 

[max_max]

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

 

[max_max]

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

 

[johnmpl]

Hi, max_max!

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

 

[max_max]

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

 

[johnmpl]

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!

 

[max_max]

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

 

[johnmpl]

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!

 

[max_max]

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

 

[max_max]

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