A specific date used for calculation of a new date

  • Thread starter Thread starter Ditte
  • Start date Start date
D

Ditte

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
 
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
 
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.
 
Hi Stefi,
thank you for your help, it works.
best regards,
Ditte
--
Ditte
Chemist


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


"Jacob Skaria" skrev:
 
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.
Click to expand...
 
Back
Top