Excel Date Functions : EDATE

Introduction to EDATE Function

EDATE function 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.

Download Sample File

Download Sample Files to work, practice and master the Date Functions in Excel.

Syntax of EDATE Function

EDATE(start_date,months)

Arguments of EDATE Function

• 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.

Example of EDATE Function in MS Excel

Here we have used EDATE with different types of arguments. Refer the screenshot below to understand more –

• In the first example, we have used 5 as a several months and it has added exactly 5 months on 1-Jan-2016 and returned 01-June-2016.
• In the second example, we have used -1 month 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.

Other Excel Date Functions Tutorials

You can explore and master other date functions in Microsoft Excel. Here is a complete list of date functions available in Microsoft Excel.

• DATE Function
• DATEVALUE Function
• DAY Function
• DAYS Function
• EDATE Function
• EOMONTH Function
• MONTH Function
• NETWORKDAYS Function
• NETWORKDAYS.INTL Function
• TODAY Function
• WEEKDAY Function
• WEEKNUM Function
• YEAR Function