Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

EDATE Function

The EDATE function is one of the date and time functions. It is used to return the serial number of the date which comes the indicated number of months (months) before or after the specified date (start_date).

Syntax

EDATE(start_date, months)

The EDATE function has the following arguments:

Argument Description
start_date A number representing the first date of the period entered using the DATE function or other date and time function.
months A number of months before or after start_date. If the months has the negative sign, the function will return the serial number of the date which comes before the specified start_date. If the months has the positive sign, the function will return the serial number of the date which follows after the specified start_date.

Notes

How to apply the EDATE function.

Examples

The figure below displays the result returned by the EDATE function.

EDATE Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action