The EDATE function in Excel takes a date and adds specified number of months. The returned result defaults as a serial date. For this reason, the returned cell needs to be formatted as a date.


  =EDATE(start_date, months) 


  • start_date – (required) Must be valid starting date
  • months – (required)

EDATE Function in Excel Usage Example:

Looking at the following example, you can see how are adding 6-months and 12-months as as well as subtracting 6-months and 12-months respectively. The individual results are below.

EDATE Function in Excel

Usage Errors

If the result cell is not formatted as a date, the returned value will be a serial date.

Leave a Reply

HLOOKUP Function in Excel

HLOOKUP Function Glossary What is HLOOKUP? HLOOKUP Example Exact Match vs Approximate Match (False vs True) HLOOKUP from another Workbook

Read More »


The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text – Date in

Read More »


AVERAGEIF (Arithmetic Mean) – Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while

Read More »
Scroll to Top