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:
=EOMONTH(start_date, months)
| Argument | Purpose |
|---|---|
| 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.
| Function | Result |
|---|---|
| =EOMONTH(A2, 3) | 30/06/2010 |
| =EOMONTH(A2, 0) | 31/03/2010 |
| =EOMONTH(A2, -2) | 31/01/2010 |
