EOMONTH Returns the date in datetime format of the last day of the month, before or after a specified number of months. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.


EOMONTH(start_date, months)


start_date – The start date in datetime format, or in an accepted text representation of a date.

months – A number representing the number of months before or after the start_date. Note: If you enter a number that is not an integer, the number is rounded up or down to the nearest integer.

Return Value

A date (datetime).

Reference Data


DAX Functions / Date and Time Functions / EOMONTH