---
title: "Use the EOMONTH Function to Return the Last Day of a Month"
slug: "eomonth-function"
description: "Learn to use EOMONTH to return the last day of a month before or after a given date in Pigment."
updated: 2025-05-30T09:43:46Z
published: 2025-08-22T10:57:28Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# EOMONTH function

## Description

Returns the last day of a month after or before a given date.

## Syntax

`EOMONTH(Date [, Month Offset])`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Date* (required) | Date | Any Dimensions | Date to return the last day of. |
| *Month Offset* (required) | Integer | No Dimension or Dimensions of argument *Date* | Offset the given argument *Date* by a number of months. By default, the offset is equivalent to 0. |

## Returns

| Type | Dimensions |
| --- | --- |
| Date | Dimensions of argument *Date* |

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `EOMONTH(DATE(1986, 11, 28))` | November 30th 1986 | The last day of the month of November 28th 1986 is November 30th 1986. |
| `EOMONTH(DATE(1989, 1, 18), 0)` | January 31st 1989 | The month offset is set to 0. The last day of the month of January 18th 1989 is January 31st 1989. |
| `EOMONTH(DATE(1986, 01, 1), 1)` | February 28th 1986 | The month offset is set to 1. The last day of the next month of January 1st 1986 is February 28th 1986. |
| `EOMONTH(DATE(1986, 1, 1), -10)` | March 31st 1985 | The month offset is set to -10. The previous 10 months of January 1st 1986 was in March 1985. The last day is March 31st 1985. |

## See also

Excel: [EOMONTH](https://support.microsoft.com/en-us/office/eomonth-function-7314ffa1-2bc9-4005-9d66-f49db127d628)

Related articles: [EDATE](/v1/docs/edate-function), [MONTH](/v1/docs/month-function), [STARTOFMONTH](/v1/docs/startofmonth-function)

> [!TIP]
> More of a hands-on learner?
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>