| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding 40 years to date
In column 'A' I have a date that an event occurred. In Column 'B' I need to
show that date 40 years later. i.e 06/25/2008 in column 'A' needs to be 06/25/2048 in column 'B'. I have a huge number of entries so it is not convenient to manually enter the new date. Is there a formula for this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding 40 years to date
Try this:
A1 = some date =DATE(YEAR(A5)+40,MONTH(A5),DAY(A5)) -- Biff Microsoft Excel MVP "Jaydeebug" wrote in message ... In column 'A' I have a date that an event occurred. In Column 'B' I need to show that date 40 years later. i.e 06/25/2008 in column 'A' needs to be 06/25/2048 in column 'B'. I have a huge number of entries so it is not convenient to manually enter the new date. Is there a formula for this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding 40 years to date
Thank you for your help
"T. Valko" wrote: Try this: A1 = some date =DATE(YEAR(A5)+40,MONTH(A5),DAY(A5)) -- Biff Microsoft Excel MVP "Jaydeebug" wrote in message ... In column 'A' I have a date that an event occurred. In Column 'B' I need to show that date 40 years later. i.e 06/25/2008 in column 'A' needs to be 06/25/2048 in column 'B'. I have a huge number of entries so it is not convenient to manually enter the new date. Is there a formula for this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding 40 years to date
You're welcome!
-- Biff Microsoft Excel MVP "Jaydeebug" wrote in message ... Thank you for your help "T. Valko" wrote: Try this: A1 = some date =DATE(YEAR(A5)+40,MONTH(A5),DAY(A5)) -- Biff Microsoft Excel MVP "Jaydeebug" wrote in message ... In column 'A' I have a date that an event occurred. In Column 'B' I need to show that date 40 years later. i.e 06/25/2008 in column 'A' needs to be 06/25/2048 in column 'B'. I have a huge number of entries so it is not convenient to manually enter the new date. Is there a formula for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding years to a date | Excel Discussion (Misc queries) | |||
| Adding values for selected years | Excel Worksheet Functions | |||
| How do I subtract a date from a date for a sum of total years? | Excel Discussion (Misc queries) | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
| Excel Adding years or months to a date | Excel Discussion (Misc queries) | |||
Linear Mode
