How to add months to date in excel?

Untitled design

Author: Sarthak Bhalerao

Table of Contents

  1. How to make Excel add months to date (EDATE)?
  2. How does the EDATE function work?
  3. Example

How to make Excel add months to date?

In Microsoft Excel, you can add a number of months to a date using the EDATE function. The EDATE function is categorized under the DATE/TIME function. The function helps add a specified number of months to a date and returns the result as a serial date. This is helpful for financial analysts to calculate maturity dates for accounts payable. The EDATE function also helps in calculating summary by month.

How does the EDATE function work?

  • Syntax:

EDATE( start_date, months)

 

  • Parameters:
  1. start_date – The starting date to use in the calculation
  2. months – The number of months to be added to start_date. It can be either a positive or negative number.

 

  • Returns:

The EDATE function returns a serial date value. A serial date is how Excel stores data internally and it represents the number of days since January 1, 1900.
If start_date is not a valid date, the EDATE function will return the #VALUE! error.

 

  • Applies to:

Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007.

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:

 

The result of the EDATE function is a serial date and can be seen in column C above. In order to see the formatted date instead of a serial date, you need to format the cells to mmm, d, yyyy. 

 

 

Leave a Reply