View Single Post
  #5   Report Post  
viktor
 
Posts: n/a
Default 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