calculating data

V

viktor

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
 
V

viktor

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!
 
N

Niek Otten

Not sure what you mean, Viktor, but maybe

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

?
 
V

viktor

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
 
R

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?
 
Top