EOMONTH Function
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 |
Download the Excel Formulas Ebook for a fast and simple guide to the most useful Excel formulas.
Follow us on
