# 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* | [Required] The starting date, specified as a serial number, string, or DateTime object |
| *months* | [Required] 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.

## Examples

`EDATE(A1,-6)`
`EDATE(R1C1,4)`
`EDATE("2004/01/09",2)` gives the result 38055