ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Formula to Calculate Dates (https://www.excelbanter.com/new-users-excel/167231-formula-calculate-dates.html)

s
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

Niek Otten
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




All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com