View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ditte Ditte is offline
external usenet poster
 
Posts: 4
Default A specific date used for calculation of a new date

Dear Jacob
Thank you for your help, it works!
Best regards,
Ditte
--
Ditte
Chemist


"Jacob Skaria" skrev:

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