The Excel EOMONTH function calculates the last day of the month a specified number of months before or after a date.
EOMONTH is often used to calculate the due date for an investment that falls on the last day of a month.
The syntax for the EOMONTH function is:
|Start_date||The date representing the start date|
|Months||The number of months before or after the start date. Enter the number as a negative for months before|
The examples below demonstrate the EOMONTH function being used to calculate the last day of the month a specified number of months before and after the date in the spreadsheet.