calculating data
 

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

calculating data
 

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

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
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

calculating data
 

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" wrote:

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

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
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

calculating data
 

Not sure what you mean, Viktor, but maybe

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

?

--
Kind regards,

Niek Otten



"viktor" wrote in message
...
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" wrote:

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

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
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

calculating data
 

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

"Niek Otten" wrote:

Not sure what you mean, Viktor, but maybe

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

?

--
Kind regards,

Niek Otten



"viktor" wrote in message
...
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" wrote:

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

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
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

calculating data
 

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?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"viktor" wrote in message
...
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

"Niek Otten" wrote:

Not sure what you mean, Viktor, but maybe

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

?

--
Kind regards,

Niek Otten



"viktor" wrote in message
...
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" wrote:

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

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
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

calculating data
 

In that case I think my answer was correct

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
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

"Niek Otten" wrote:

Not sure what you mean, Viktor, but maybe

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

?

--
Kind regards,

Niek Otten



"viktor" wrote in message
...
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" wrote:

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

--
Kind regards,

Niek Otten

"viktor" wrote in message
...
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