How to calculate the Maturity Date of an Investment

If you have an investment and would like to know the exact date that it will mature, use the EDATE function. Let’s say your investment will give a yield in 12 months, but you want to know the actual date, you can calculate it with the EDATE function which returns a serial number representing a date, which is a specified number of months before or after a start date. Try our example exercise to learn how.

Note: Download the workbook to practice this exercise 

Applies To: Microsoft Excel 2010 and 2013

1. With reference to the practice workbook, select cell D2.







2. Type =E and double click EDATE from the drop down list.








3. Select cell B2.

4. Add a comma(,) and select cell C2.

5. Press Enter.

6. A serial number representing the date will be displayed.

7. To convert the serial number to a date:
a. Right click cell D2.
b. Select Format Cells.
c. Select Date.
d. On the right hand side; select the yyyy,mm,dd date format.
e. Select OK.












8. Copy the formula down to cell D15.







As you can see the maturity dates for investments can be calculated with an easy to use formula.