Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
How do I change the value in cell based on a future date | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Show a date based on today | Excel Worksheet Functions | |||
Extract date from cell | Excel Worksheet Functions |