---
title: EOMONTH
description: Learn how to use the EOMONTH function to calculate the last day of a month for date-based financial calculations and monthly metrics tracking
---
import { Aside, Steps } from '@astrojs/starlight/components';

# EOMONTH

The EOMONTH function is used to calculate the last day of the month that is a specified number of months before or after a given date.

## Applicable to

Calculated Columns

## Return Value

The return value of the EOMONTH is a new date representing the end of the month.

## Remark

* The months argument can be positive to add months to the @StartDate, or negative to subtract months from the @StartDate.
* The months argument can be a whole number or a column reference containing a number.
* The EOMONTH function is useful for calculating future or past dates based on a given date, and it is commonly used in financial and accounting scenarios for date calculations.
* The decimal number in the month argument will be rounded to the nearest whole number.
* The EOMONTH function is useful for calculating the end of a month for various purposes, such as financial calculations or date-based analysis. It can be helpful when you need to find due dates or track monthly metrics.

## Syntax

```
EOMONTH(<expression>, month)
```

<br/>

<Aside type="tip">
You can call in the system defined date function start date and end date as `@StartDate` and `@StartDate` respectively.
</Aside>

<br/>

## EOMONTH in Calculated Columns



| Parameter | Description |
|---|---|
| Expression | The start date of the period to which you want to add or subtract months. |
| Month | Number of months you want to add (if positive) or subtract (if negative) from the start date. |

Steps to use EOMONTH in Calculated Columns

<Steps>
1. Write the EOMONTH function. For instance ```EOMONTH(<expression>, month)```
2. Replace `<expression>` with the start period. You can also call in `@StartDate` function.
3. Replace `month` with the month value required.
4. To learn how to add calculated columns in Infoveave, visit the section [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/).
</Steps>

<br/>

**Example**

Suppose you want to create a column that is three months after sales date, you can use the EOMONTH function as follows

```
EOMONTH( DATE(2024, 2, 01),3)
```

The calculated column will return the value 2024-05-31.