# EOMONTH

The `EOMONTH` function returns the date of the last day of the month that is the indicated number of months before or after the start date. This function is commonly used to calculate due dates, expiration dates, and other dates relative to a specified start date.

## Usage

Use the `EOMONTH` formula with the syntax shown below, it has 2 required parameters:

Parameters:
1. start_date (required):
The date from which to calculate the result. Must be a valid date.
2. months (required):
The number of months to add or subtract from the start_date. Must be an integer.

## Examples

Here are a few example use cases that explain how to use the `EOMONTH` formula in Google Sheets.

### Calculate due dates

Use `EOMONTH` to calculate due dates for invoices, bills, or other payments. For example, if an invoice is due 30 days after the end of the month, you can use `EOMONTH` to calculate the end of the month and then add 30 days.

### Calculate expiration dates

Use `EOMONTH` to calculate expiration dates for contracts, warranties, or other time-limited agreements. For example, if a warranty is valid for 1 year from the end of the month of purchase, you can use `EOMONTH` to calculate the end of the month of purchase and then add 1 year.

### Calculate end of month

Use `EOMONTH` to calculate the last day of the month for a given date. For example, if you have a list of dates and you want to group them by month, you can use `EOMONTH` to get the last day of each month and then use that as a grouping criterion.

## Common Mistakes

`EOMONTH` not working? Here are some common mistakes people make when using the `EOMONTH` Google Sheets Formula:

### Incorrect date format

Ensure that the start_date argument is entered as a valid date format recognized by Google Sheets. For example, use the DATE function to create a date, or enter a date in the format YYYY-MM-DD.

### Incorrect number of months

Ensure that the months argument is a numeric value representing the number of months added to the start_date. If the value is negative, it will subtract months from the start_date.

### Incorrect order of arguments

Ensure that the start_date argument is entered first, followed by the months argument.

The following functions are similar to `EOMONTH` or are often used with it in a formula:

• `EDATE`

The `EDATE` function in Google Sheets returns a date that is a specified number of months before or after a specified date. It is most commonly used to calculate due dates for invoices, project deadlines, or loan repayments.

• `DATE`

The `DATE` formula is used to create a date object in Google Sheets. It takes three arguments: year, month, and day and returns a date. This formula is useful when you need to perform date calculations or create date-based charts and graphs.

• `MONTH`

The `MONTH` formula is used to extract the month from a given date, returning it as a number between 1 and 12. This function is commonly used to summarize and analyze data that includes dates.

• `YEAR`

The YEAR formula in Google Sheets returns the year of a specified date. This function is useful when you need to extract the year from a date for analysis or calculations. The YEAR formula takes one argument, which is the date from which to extract the year. The output is a four-digit number representing the year.

You can learn more about the `EOMONTH` Google Sheets function on Google Support.