|
A specific date used for calculation of a new date
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 |
A specific date used for calculation of a new date
=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 |
A specific date used for calculation of a new date
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 |
A specific date used for calculation of a new date
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 |
A specific date used for calculation of a new date
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 |
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 |
A specific date used for calculation of a new date
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 |
A specific date used for calculation of a new date
You are welcome! Thanks for the feedback!
Stefi €˛Ditte€¯ ezt Ć*rta: 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 |
| All times are GMT +1. The time now is 06:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com