EOMONTH
TheEOMONTH
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.
 How to use
EOMONTH
formula?  Examples of using
EOMONTH
formula EOMONTH
formula not working? Similar formulas to
EOMONTH
Usage
Use the EOMONTH
formula with the syntax shown below, it has 2 required parameters:
 start_date (required):
The date from which to calculate the result. Must be a valid date.  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 theEOMONTH
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 timelimited 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 YYYYMMDD.
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.
Related Formulas
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 datebased 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 fourdigit number representing the year.
Learn More
You can learn more about the EOMONTH
Google Sheets function on Google Support.