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:
- 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.
- Use a positive number in months to get a future date and a negative number for a past date.
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.
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 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 ﬁnd him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.