With a valid full date in A1; try the below formula

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

If this post helps click Yes
---------------
Jacob Skaria


"Ditte" wrote:

Hi,
My question is that I would like to calculate a new date from a date in a
nother column, se below

A1 10.2009

A3 = A1+ 1year

It is probaly I simple question but i would be happy if any one could help me.
thanks

--
Ditte
Chemist