<!-- https://learnsql.cpetoday.com/functions/dax/eomonth -->
# EOMONTH

Language: DAX
Category: Date and time
Syntax: EOMONTH(<start_date>, <months>)
Summary: Returns the last day of the month that is a given number of months before or after the start date.
Returns: A date.
Level: Beginner
Related: EDATE, ENDOFMONTH, DATE, MONTH, CLOSINGBALANCEMONTH

## 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
- start_date: the date to count from, such as an invoice date or the report date. Required.
- months: the number of months to move, positive for later and negative for earlier. Required. Use 0 for the same month.

## 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.

```dax
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.

```dax
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
- EOMONTH returns the last day of the month, not the same day of the next month. Use EDATE when you need the same day number.
- Pass the months as a whole number. A value of 1.5 is not a half month.
- The result is a date with no time part, so it matches the Calendar's date column.
- The function does not know business days. If a due date falls on a weekend, use a workday rule in a separate column.

## 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.
