Formula to Calculate Dates

S

S

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
 
N

Niek Otten

=DATE(YEAR(A1)+5,MONTH(A1),DAY(A1))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Calculating Dates 1
Help with determining # of days from certain dates 2
Use excel to calculate an expiration date 1
MS Project. Real progress of the project, % complete 1
Month days over a time period 5
Space at end of multi page list to accommodate new entries 1
Allocate an income payment over a date range (tax years) 7
Formula to fill cells based on Date of Arrival and Date of Departure 1

Top