Using formulas to determine date in one cell based on date in anot
Term: 3yrs.
Instrument Date
3/24/1998 Expired: 3/23/2001
In the example above, the date on the far left represents the beginning date
of a lease. The date shown as "Expired:" represents the expiration date 3
years later.
I would like to enter a formula in the cell representing the expiration date
(which ends at midnight on 3/23/2001) utilizing the term of 3 years, in this
case. Can this be done in Excel? There are also times when the number of
years is 1, 2, 4 or 5.
Thank you very much!
Gary B.
|