| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Linear Mode
