---
url: /cube-functions/eomonth.md
description: >-
  Calculates the last day of the month that is the specified number of months
  before or after a given date.
---

# EOMONTH 

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

```js
EOMONTH(start_date, months)
```

#### Parameters

* `start_date` - The start date or time value, represented as an Excel date value.
* `months` - The number of months before or after the start date.

#### Examples

```js
EOMONTH("2022-04-17", 2)

```

**Result:** `44742`

**Note:** Calculates the last day of the month that is 2 months after the start date (2022-04-17).

```js
EOMONTH(45033, -1)

```

**Result:** `45016`

**Note:** Calculates the last day of the month that is 1 month before the start date (45033).