EOMONTH

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.


Syntax

EOMONTH(start_date, months)

Parameters

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

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Date and Time Functions / EOMONTH