Excel EDATE Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel EDATE Function (Example + Sample File)

What is EXCEL EDATE FUNCTION

The Excel EDATE Function is listed under Microsoft Excel's Date Functions category. It returns a date after adding a specified number of months to it. In simple words, you can add (with a positive number) or subtract (with a negative number) months from a date.

How to use it

To learn how to use the EDATE function in Excel, you need to understand its syntax and arguments:

Syntax

EDATE(start_date,months)

Arguments

  • start_date: The date from which you want to start the calculation.
  • months: The number of months to calculate the future or the past date.

Notes

  • Use a positive number in months to get a future date and a negative number for a past date.

Example

To master EDATE function we need to try it out in an example, so make sure to check out the below one:

Here we have used EDATE with different types of arguments.

In the first example, we have used 5 as a number of months and it has added exactly 5 months in 1-Jan-2016 and returned 01-June-2016.

In the second example, we have used -1 months and it has given 31-Dec-2016, a date which is exactly 1 month back from 31-Jan-2016.

In the third example, we have inserted a date directly into the function.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.