> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# EndOfMonth

Returns the last day of the month of a Date value.

## Usage

`EndOfMonth(date)`

**date** (required) The date from which the end of month is to be computed.

## Example

Extract the last day of the month from the \[Invoice Date] column:

```
EndOfMonth([Invoice Date])
```

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/8863ab75121e4fc6e323514d7125a99700828109ad65422256eb6917d11b9085/assets/docs-images/30861f6-Screen_Shot_2020-07-30_at_12.29.26_PM.png)

```
EndOfMonth(Date("2023-03-07"))
```

* Returns 2023-03-31 23:59:59.

## Related resources

* [LastDay](/docs/lastday)
* <a href="https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html" target="_blank" rel="noopener noreferrer">
    Quickstart: Common date functions and use cases
  </a>