# 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* | [Required] The starting date, specified as a serial number, string, or DateTime object |
| *months* | [Required] 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).

## Examples

`EOMONTH(A3,6)`
`EOMONTH(R3C1,-4)`
`EOMONTH("2004/01/09",2)` gives the result 38077