# EOMONTH

## Content

This function calculates the date for the last day of the month (end of the month) which is the indicated number of months before or after the starting date.

## Syntax

`EOMONTH( startdate, months )`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *startdate* | Starting date |
| *months* | Number of months before (negative) or after (positive) the starting date; if not an integer, the number is truncated |

Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4).

## Data Types

Accepts numeric, string, or DateTime object data for the *startdate* argument and numeric data for the *months* argument. Returns a DateTime object.

## Examples

`EOMONTH(A3,6)`

`EOMONTH(R3C1,-4)`

`EOMONTH("2004/01/09",2)` gives the result 3/31/2004 12:00:00 AM.