Downloads
DAXDate and timeBeginner

EDATE

Returns the date that is a given number of months before or after the start date, on the same day of the month.

Syntax
EDATE(<start_date>, <months>)

Returns: A date.

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

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.

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.

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

Things to watch

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.

Related functions

All DAX functions · View as Markdown · DAX fundamentals