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.

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

Your email address will not be published. Required fields are marked *

NETWORKDAYS Function

The NETWORKDAYS function in Excel allows you to return the number of workdays between two specified dates. This function automatically excludes weekends and gives you

Read More »

MINUTE Function

The MINUTE function in Excel returns the minute component of a specified time as a number between 0-59. Syntax: =MINUTE(serial_number) Arguments serial_number – (required) The

Read More »

Learn Faster!