<!-- https://learnsql.cpetoday.com/functions/dax/edate -->
# EDATE

Language: DAX
Category: Date and time
Syntax: EDATE(<start_date>, <months>)
Summary: Returns the date that is a given number of months before or after the start date, on the same day of the month.
Returns: A date.
Level: Beginner
Related: EOMONTH, DATEADD, DATE, PARALLELPERIOD, DATEDIFF

## What it does
EDATE moves a date forward or back by whole months and keeps the day number. Finance teams use it to find a note's maturity date from its issue date and term, to build payment schedules that fall on the same day each month, and to find contract renewal dates. Its sister function EOMONTH returns month ends instead.

## Syntax and arguments
- start_date: the date to move from, such as the issue date of a note. Required.
- months: the number of months to add, or subtract when negative. Required.

## Example
A company issues a 36-month note on March 15, 2026. The treasury team wants the maturity date in a table of debt instruments.

```dax
Maturity Date = EDATE('Debt'[IssueDate], 'Debt'[TermMonths])
```

With a term of 36 months, the maturity date is March 15, 2029. The same formula works for any term in the table, so a 60-month lease gets its own end date with no separate formula.

## Example: a second, different use
A monthly payment schedule that starts on a fixed date and runs for 12 payments. Each row adds one month to the first payment date, using the row number of the schedule as the number of months.

```dax
Payment Date = EDATE('Schedule'[FirstPaymentDate], 'Schedule'[PaymentNumber] - 1)
```

## Things to watch
- A start date on the 31st can land in a shorter month. EDATE returns the last day of that month, so January 31 plus one month gives February 28 or February 29.
- EDATE returns a date with no time part.
- Use EOMONTH for month-end schedules. Mixing the two in one schedule creates dates that jump between month ends and mid-month days.
- EDATE does not check business days. A payment due on a weekend still has the weekend date.

## In business terms
EDATE is the usual tool for debt maturity tables, lease end dates, payment calendars, subscription renewals and the aging of contracts. It keeps payment dates aligned with the original contract day.
