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:
|The date representing the start date
|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.