EDATE Function(WS)

Description

The Microsoft Excel EDATE function adds a specified number of months to a date and returns the result as a serial date.

If you want to follow along with this tutorial, download the example spreadsheet.

Download Example

Syntax

The syntax for the EDATE function in Microsoft Excel is:

EDATE( start_date, months )

Parameters or Arguments

start_date

The starting date to use in the calculation.

months

The number of months to add to the start_date. It can be a positive or negative value.

Note

• If a decimal value is provided for months, the EDATE function will only add the integer portion to start_date.
• If start_date is not a valid date, the EDATE function will return the #VALUE! error.
• A serial date is how Excel stores dates internally and it represents the number of days since January 1, 1900.

Applies To

• Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007

Type of Function

• Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel EDATE function examples and explore how to use the EDATE function as a worksheet function in Microsoft Excel:

The result of the EDATE function is a serial date and can be seen in column C above.

Most often you will want a formatted date rather than a serial date. Column D demonstrates the serial date returned by the EDATE function that has been formatted using mmm d, yyyy.

Based on the Excel spreadsheet above, the following EDATE examples would return:

=EDATE(A2,B2)
Result: 42426  'Which can be formatted as "Feb 26, 2016"

=EDATE(A3,B3)
Result: 42475  'Which can be formatted as "Apr 15, 2016"

=EDATE(A4,B4)
Result: 42617  'Which can be formatted as "Sep 4, 2016"

=EDATE(A5,B5)
Result: 42520  'Which can be formatted as "May 30, 2016"

=EDATE("1/27/2016",3)
Result: 42487  'Which can be formatted as "Apr 27, 2016"