View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default 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