| 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? |
| 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) | |||
Threaded Mode
