# EDATE

## Content

This function calculates the date which is the indicated number of months before or after a specified date.

## Syntax

`EDATE( startdate, months )`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *startdate* | Starting date |
| *months* | Number of months before (negative) or after (positive) the starting date; if not an integer, the number is truncated |

## Remarks

Use this function to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

## Data Types

Accepts numeric, string, or DateTime object data for the *startdate* argument and numeric data for the *months* argument. Returns a DateTime object.

## Examples

`EDATE(A1,-6)`

`EDATE(R1C1,4)`

`EDATE("2004/01/09",2)` gives the result 3/9/2004 12:00:00 AM.