# Excel EDATE Function

HomeExcel FunctionsExcel 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: 