If

[Ana_Guerra]

=SE(G24>50;J24+1;J24+2)

this formula should return me has a number: if G24 bigger then 50, H24 should be year I24+1, if G24 less then 50, should be year I24+2

[#2]

@Ana_Guerra 

=SE(G24>50;ANO(I24)+1;SE(G24<50;ANO(I24)+2;""))

You can try this formula.

[#3]

the same

note that

cell E has a formula =ANO(D24)-ANO(E24)

@OliverScheurich 

[#4]

@Ana_Guerra 

=ANO(D24)-ANO(E24)

If this formula is in column E it should create a circular reference. Unfortunately i'm now unsure what you want to do. Can you attach a sample file without sensitive data?

[#5]

@OliverScheurich 

not able to attache file but try to send you all cells forms

F15 "=ANO(D15)-ANO(E15)"

G15 "=SE(F15>50;ANO(H15)+1;SE(F15<50;ANO(H15)+2;""))"

[#6]

@Ana_Guerra 

It seems that the formulas work as expected. You only have to change the format of the cells.

In my example in column H the format is date (Datum in german)

And in column G the format is standard (Standard in german)

[#7]

end up resolving by opening new page and puting all data back, formula was ok, but not sure cell format resolving in error
thanks for all your help