Formula to Calculate Dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S - 24 Nov 2007 17:30 GMT

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 to this Message

Niek Otten - 24 Nov 2007 17:43 GMT

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

Signature

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:
[quoted text clipped - 7 lines]
|
| BTW: Using Excel 2000

Reply to this Message