Dear David
Thank you very much for your help. I have formated the date so it will work.
Best regards,
Ditte
--
Ditte
Chemist


"David Biddulph" skrev:

10.2009 isn't a specific date.
If in that cell you have a real date and it is merely formatted as mm.yyyy,
then your formula would be =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

You may, however, wish to think about what answer you want if the date in A1
is 29 Feb 2008.

Note also that A3 is not in another column compared with A1, they are in the
same column, but different rows.
--
David Biddulph

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