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.
Syntax:
=EDATE(start_date, months)
Arguments
- 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.
Usage Errors
If the result cell is not formatted as a date, the returned value will be a serial date.