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.
- How to use
- Examples of using
EOMONTHformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
EOMONTH formula in Google Sheets.
Calculate due dates
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
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
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.
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:
EDATEfunction 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.
DATEformula 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.
MONTHformula 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.
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.