| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula to Calculate Dates
I need to enter one date, and have it compute the future date based on the
number of years: For Example: - Date Added: June 2007 - Number Of Years: 5 Year - Expiration Date (Need Formula): June 2012 How would I get that result. BTW: Using Excel 2000 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula to Calculate Dates
=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))
-- Kind regards, Niek Otten Microsoft MVP - Excel "S" wrote in message ... |I need to enter one date, and have it compute the future date based on the | number of years: | | For Example: | - Date Added: June 2007 | - Number Of Years: 5 Year | - Expiration Date (Need Formula): June 2012 | | How would I get that result. | | BTW: Using Excel 2000 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate differences between dates?? | Excel Discussion (Misc queries) | |||
| Formula help, calculate dates and name in multiple columns | Excel Discussion (Misc queries) | |||
| formula to calculate difference between dates and times | Excel Discussion (Misc queries) | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| Can someone help with a formula to calculate dates? | Excel Discussion (Misc queries) | |||
Linear Mode
