EDATE is a date and time function in excel which adds a given number of months into a date and gives us a date in a numerical format of date, the arguments this function takes is date and integers, date as the start date to begin with and number of months are integers to add it to the given start date, the output returned by this function is also a date value, the method to use this function is =Edate( Start Date, Months).
Syntax: =EDATE (start_date, months)
The EDATE function syntax has the following arguments:
- Start_date Required. A date that represents the start date. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
-
Months Required. The number of months before or after start_date. A positive value for months yields a future date; a negative value yields a past date.
Example: Let’s look at some Excel EDATE function examples and explore how to use the EDATE function as a worksheet function in Microsoft Excel:
Syntax: =EDATE(A2,B2)
Result:
Based on the Excel spreadsheet above, the following EDATE examples would return:
Syntax: =EDATE(A3,B3)
Result: 15/04/2016
Syntax: =EDATE(A4,B4)
Result: 04/06/2016
Syntax: =EDATE(A5,B5)
Result: 20/05/2016
Syntax: =EDATE(A6,B6)
Result: 01/01/2018
Syntax: =EDATE(A7,B7)
Result: 01/12/2017
Syntax: =EDATE(A8,B8)
Result: 30/03/2016
Syntax: =EDATE(A9,B9)
Result: 30/03/2017
Syntax: =EDATE(A10,B10)
Result: 30/04/2019
Syntax: =EDATE(A11,B11)
Result: 15/02/2020
Syntax: =EDATE(A12,B12)
Result: 15/11/2019
Note:
- #NUM! error – Occurs when the date resulting from the calculation is not a valid date.
- #VALUE error – Occurs if:
- The supplied start_date is not a valid Excel date; or
- Any of the supplied arguments are non-numeric.
- If we provide a decimal value for months, the EOMONTH function will only add the integer portion to start_date.