calculating data

[Guest]

how can i calculate the final data betwen two cells?
for example in A1(date) i have 01/01/2005; in A2(numeric) i have 12(month)
and in A3 i must have the final data 01/02/2006.
thanks

 

[Niek Otten]

=DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))

 

[Guest]

thanks for the formula;it's very good!
i have one more question: in A3 the calculation starts from A1 +1( if the
A1=01/01/2005 in A3 i must have A2(12)+01/02/2005
thanks again!

 

[Niek Otten]

Not sure what you mean, Viktor, but maybe

=DATE(YEAR(A1),MONTH(A1)+A2+1,DAY(A1))

?

 

[Guest]

i'm sorry for my poor explication; what i want to say is that in A3 the
calculation start with the next month from A1(ex.: A1=15/01/2005;
A2=12(month) in A3 i must have 15/02/2005 plus 12 month = 15/02/2006)
thanks again,
viktor

 

[Ragdyer]

Niek's last suggested formula,

=DATE(YEAR(A1),MONTH(A1)+A2+1,DAY(A1))

Does *exactly* what you're asking for.

Have you tried it?

 

[Niek Otten]

In that case I think my answer was correct