EDATE Returns the date that is the indicated number of months before or after the start date. Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.


EDATE(start_date, months)


start_date – A date in datetime or text format that represents the start date.

months – An integer that represents the number of months before or after start_date.

Return Value

A date (datetime).

Reference Data


DAX Functions / Date and Time Functions / EDATE