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

1. Re: correction formula given increase every 2 months

=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 on excel 2003?
max_max

2. Re: correction formula given increase every 2 months

No... IFERROR is a function for Excel 2007 and newer.

You can use:
=IF((B2>0)*(B4>B2),MIN(INT(DATEDIF(B4,B2,"y")/6),5)&" anno/i - "&2*MOD(MIN(DATEDIF(B4,B2,"y"),30),6)&" mese/i","")

Blessings!

3. Re: correction formula given increase every 2 months

Hi johnmpl,
With your new formula you do not see anything, the cell is empty.
max_max

4. Re: correction formula given increase every 2 months

Originally Posted by max_max
Hi johnmpl,
With your new formula you do not see anything, the cell is empty.
max_max
Sorry, my mistake. Check this formulae:
=IF((B4>0)*(B2>B4),MIN(INT(DATEDIF(B4,B2,"y")/6),5)&" anno/i - "&2*MOD(MIN(DATEDIF(B4,B2,"y"),30),6)&" mese/i","")

5. Re: correction formula given increase every 2 months

Hi johnmpl,
the new formula work, thank you
max_max