Hi Stefi,
thank you for your help, it works.
best regards,
Ditte
--
Ditte
Chemist


"Stefi" skrev:

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

€žDitte€� ezt Ã*rta:

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