Downloads
DAXDate and timeBeginner

EOMONTH

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

Syntax
EOMONTH(<start_date>, <months>)

Returns: A date.

What it does

EOMONTH finds the last calendar day of a month, counted from a start date. Finance teams use it for accrual dates, for end-of-month payment terms, for the reporting date of a monthly pack and for maturity dates that fall on a month end. Zero months means the same month, 1 means next month and -1 means the prior month.

Syntax and arguments

Example

A supplier's invoices are due at the end of the month after the invoice month, which is often written as "net EOM" or "due end of next month". The receivables team wants a due date column.

Due Date (EOM terms) = EOMONTH('Invoices'[InvoiceDate], 1)

An invoice dated October 29, 2026 is due on November 30, 2026. An invoice dated December 3 is due on January 31 of the next year. The formula always returns the last day of the target month, so the due date is never a day in the middle of a month.

Example: a second, different use

A monthly report should always show the last closed month. If the report runs in the first days of November, the last closed month is October, so the reporting date is the end of the prior month.

Last Closed Month End = EOMONTH(TODAY(), -1)

The result is September 30 for any date in October. TODAY changes each day, so for a report that must reproduce a past month, use a fixed date parameter instead.

Things to watch

In business terms

EOMONTH supports accrual schedules, end-of-month payment terms, debt maturity dates, rent and lease schedules that run to month end, and the reporting date for every monthly close pack.

Related functions

All DAX functions · View as Markdown · DAX fundamentals