Using formulas to determine date in one cell based on date in anot

G

Gary

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.
 
A

Arvi Laanemets

Hi

With instrument date p.e. in cell A2
=MIN(DATE(YEAR(A2)+3,MONTH(A2),DAY(A2)),DATE(YEAR(A2)+3;MONTH(A2)+1,0))

(Second part of formula is for cases the date in A2 is 29 February of leap
year - in such cases last of Febryary is returned as expire date)
 

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

sum of info in a range based on dates 4
Combining multiple formulas in one cell 5
Help With Formula For Cell Addresses 2
Using CF to change colour in cell based on date? 4
Please help with formula (multiple ifs to determine due date) 3
Counting populated cells in another worksheet 0
Date sensitive calculation refresh 7
Excel 2007 text import as text not date 3

Top