| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding years to a date
"sumitk" wrote in message
... Hi. Is there an Excel formula that I could use to add certain number of years to a given date? For example, if todays date is 04/30/06... I would like to see what the date would be one year from now, three years from now, five years from now and so on.. =DATE(YEAR(A1)+3,MONTH(A1),DAY(A1)) to add 3 years. -- David Biddulph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours to a date | Excel Worksheet Functions | |||
| Date Formula - in Years | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Trying to get the next date exactly 5 years ago.. | Excel Worksheet Functions | |||
| Adding a line after a date | Excel Discussion (Misc queries) | |||
Threaded Mode
