Thursday, August 11, 2016

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.
Excel EDATE function
If you want to follow along with this tutorial, download the example spreadsheet.

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:
Excel EDATE function
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"