Date 15-Jan-11, formula, description, result, edate(A2,1 the date, one month after the date above 15-Feb-11.
Select a blank cell, type the formula edate(A2,3) (In the formula 3 means "3 months into it, and then drag the Fill Handle to the range as you need.
Problems can occur if dates are entered as text.
Warning: If you attempt to input text representations of dates into Excel functions, they may be interpreted differently, depending on the date system and date interpretation settings on your computer.
A B 1 Settlement Date: 01-Apr-2015 2 Maturity Date: 31-Mar-2025 3 duration( B1, B2, 10, 8, 4 ) The function returns the Duration.Syntax, edate(start_date, months the edate function syntax has the following arguments: Start_date, required.Semi-Annually 4, quarterly basis, an optional integer argument which specifies the financial day count basis that is used by the security.For example, edate 1/31/2015 1) returns the date "2/28/2015" and edate 1/31/2016 1) returns "2/29/2016 since 2016 is a leap year.This article will introduce two tricky ways to solve.
Further examples of the Excel Duration function are provided on the Microsoft Office website.
In these conditions, please calculate expiration dates with proper formulas in below table:.
Maturity, the maturity date of the security (i.e.
This must be one of the following: 1, annually.You'll also learn how to troubleshoot, trace errors, and fix problems.How to quickly calculate the expiration date in Excel?Example, copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.Make sure you have a solid foundation in Excel formulas! .Note that the date arguments should be input to the Duration function as either: References to cells containing dates or Dates returned from formulas.